Why does GRANT ALL ON *.* TO 'username'@'anotherservername' IDENTIFIED BY 'password'; not work but GRANT ALL ON database.* TO 'username'@'anotherservername' IDENTIFIED BY 'password'; does?
This code doesn't work although it looks like it.
Code:
mysql> GRANT ALL ON *.* to 'username'@'webserver' identified by 'password';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
This code does work.
Code:
mysql> GRANT ALL ON mu.* to 'username'@'webserver' identified by 'password';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
I have over 100 databases so I don't want to do this manually.
When I grant all on *.* and go into mysql administrator, it shows the username@webserver but it has no access to any databases like it should.
Databases are not located in the normal location of /var/lib/mysql, it is at /data/mysql.
Selinux has mysqld disabled for protection.
Please excuse me if this is the wrong place to put this.
Thanks,
Shawn