- #HELP I DELETED ALL MY PATIENTS FROM MY EPIC PATIENT LIST HOW TO#
- #HELP I DELETED ALL MY PATIENTS FROM MY EPIC PATIENT LIST UPDATE#
So I found this post and tried to follow the directions but. I made the apparently common mistake of deleting the root user when creating another user, I was locked out! Thats mean, than your installation is incorrect and you should find where are your mysql binaries, and need enter the directory into you PATH variable. If you got something like: -bash: mysql: command not found You can loose all you data if do something wrong. Mysql -vv GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION Open Terminal.app (Applications/Utilities)Įnter the following commands: sudo mysqld -skip-grant-tables & #start your MySQL server without access control If not, you must consult the docs for your MySQL installation. You probably have an PreferencePane in your system preferences.
#HELP I DELETED ALL MY PATIENTS FROM MY EPIC PATIENT LIST HOW TO#
How to do this, depends on what installation did you use for MySQL.
#HELP I DELETED ALL MY PATIENTS FROM MY EPIC PATIENT LIST UPDATE#
Update er set Create_user_priv='y' where user='root' Update er set Alter_routine_priv='y' where user='root' Update er set Create_routine_priv='y' where user='root' Update er set Show_view_priv='y' where user='root' Update er set Create_view_priv='y' where user='root' Update er set Repl_client_priv='y' where user='root' Update er set Repl_slave_priv='y' where user='root' Update er set Execute_priv='y' where user='root' Update er set Lock_tables_priv='y' where user='root' Update er set Create_tmp_table_priv='y' where user='root' Update er set Super_priv='y' where user='root' Update er set Show_db_priv='y' where user='root' Update er set Alter_priv='y' where user='root' Update er set Index_priv='y' where user='root' Update er set References_priv='y' where user='root' Update er set Grant_priv='y' where user='root' Update er set File_priv='y' where user='root' Update er set Process_priv='y' where user='root' Update er set Shutdown_priv='y' where user='root' Update er set Reload_priv='y' where user='root' Update er set Drop_priv='y' where user='root'
Update er set Create_priv='y' where user='root' Update er set Delete_priv='y' where user='root' Update er set Update_priv='y' where user='root' Update er set Insert_priv='y' where user='root'
Update er set Select_priv='y' where user='root' Open TextEdit.app and select in Format -> "Make plain text".Ĭut and paste the following into TextEdit and save it into your HOME folder with name restore_root_privileges.sql update er set Super_priv='y' where user='root' Remove 'skip-grant-tables' from my.cnf under the section Password = Password('whatevernewpassword'), Type mysql with no password and hit enter Get someone with SysAdmin rights and do the following:Īdd 'skip-grant-tables' to my.cnf under the section
0 kommentar(er)
