Then after searching I tried this command as well - GRANT ALL PRIVILEGES ON *. ![]() You’ll be presented with the Connect to Database window, which looks like the follwing figure: To create the connection, enter the following details: For Connection Name. As of MySQL version 5.5.10, users have the ability to use authsocket authentication. creating a MySQL user that ONLY has permission to perform a MySQL dump. Create a new connection by clicking the + icon next to MySQL Connections in the main window. Turns out, this had nothing to do with WSL at all, but rather the authentication method for the MySQL user. Workbench In MySql Workbench goto to Edit > Preferences > Administration. Take a look at the following example: mysql> CREATE USER developer IDENTIFIED BY 'developer' ERROR 1396 (HY000): Operation CREATE USER failed for 'developer''' mysql> DROP USER. Once you’ve installed MySQL Workbench on your computer, launch the program. MySQL will respond with the same error, but after that you can create the user again. I tried almost every syntax by changing the to tried removing and adding the APOSTROPHE on 'root' in IDENTIFIED BY 'root', To fix this, you need to run a DROP USER statement for the same user account. When I run this command,I get the error- GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTERĮRROR 1064 (42000): You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'root'' at line 1 ![]() I was trying to install wordpress on ubuntu using the link and struck at
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |