Centos 7 & MariaDB database name bug

There is a know bug in MariaDB with databases containing _ in the name.

If you need to grant privaleges to the database 'ih-database_name', use the following format...

GRANT ALL PRIVILEGES ON `ih-database\_name` TO `user`@`1,2,3,4` IDENTIFIED BY 'passwordhere';

Note the difference between   ` and '

Was this answer helpful?

 Print this Article

Also Read

Forgotten Mysql root password

https://stackoverflow.com/questions/7534056/mysql-root-password-change   sudo service mysql...