I was having the exact same issue with trying to connect from MySQL Workbench. You can easily check for this with the following command: SELECT host, user FROM user This means that either the user does not exist at all OR that the combination does not exist. You could run into the following error, which is a bit confusing:ĮRROR 1410 (42000): You are not allowed to create a user with GRANT You need add/change the following two lines in /etc/mysql/my.cnf and restart mysql: bind-address = 0.0.0.0 GRANT ALL ON *.* TO you would somehow run into the following error:ĮRROR 1130 (HY000): Host ‘1.2.3.4’ is not allowed to connect to this GRANT ALL ON my_database.my_table TO Grant user permissions to all tables and databases from all hosts. GRANT ALL ON my_database.* TO Grant user permissions to my_table in my_database from localhost. Alternative privileges can be applied as follows (be careful and remember the least-privilege principle): - Grant user permissions to all tables in my_database from localhost. However, using the default root account to let an application connect to the database is not the preferred way. Note: instead of a self-created user you can use root to connect to the database. I see a lot of (wrong) answers, it is just as simple as this: USE mysql ĬREATE USER IDENTIFIED BY ALL ON *.* TO PRIVILEGES
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |