Another day another ERROR on my life. Really?????

Started by atsuyim, May 08, 2017, 09:28:59 AM

Previous topic - Next topic

atsuyim

Just solved this  issue https://www.simplemachines.org/community/index.php?board=86.0 and now again i got another issue  :-X
This is not a major issue but for some reason after creating a database and user i cannot grand it cause it show some error..

My Database

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| MYDATABASENAME            |
| mysql              |
| performance_schema |
| sys                |
+--------------------+



My user

mysql> select Host,User from mysql.user;
+-----------+------------------+
| Host      | User             |
+-----------+------------------+
| localhost | SMFUSER      |
| localhost | debian-sys-maint |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+


Everything looks normal until here but when i try to grand with all privileges i get this ERROR

mysql> GRANT ALL PRIVILEGES ON 'MYDATABASENAME'.* TO 'SMFUSER'@'localhost';
ERROR 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 ''MYDATABASENAME'.* TO 'SMFUSER'@'localhost'' at line 1


What might be the possible cause of this error?
Like mathematics, computer science will be somewhat different from the other sciences, in that it deals with artificial laws that can be proved, instead of natural laws that are never known with certainty.

– Donald Knuth

atsuyim

ah it was just a small mistake i think the problem have been solved now
mysql> GRANT ALL ON MYDATABASENAME.* TO 'SMFUSER'@'localhost';
Like mathematics, computer science will be somewhat different from the other sciences, in that it deals with artificial laws that can be proved, instead of natural laws that are never known with certainty.

– Donald Knuth

Advertisement: