What is the reason this Mysql Error ?
What is the reason this Mysql Error ?
[root@webserver root]# mysql -u root -p; Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4534627 to server version: 4.0.13-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> SELECT VERSION(); +-----------------+ | VERSION() | +-----------------+ | 4.0.13-standard | +-----------------+ 1 row in set (0.05 sec) mysql> SHOW DATABASES; +----------------+ | Database | +----------------+ | algoritma_DB | | arsiv_haber | | gecici_anket | | hat_rehberi | | hat_rehberi_v2 | | mysql | | navigator | | test | | vipar | +----------------+ 9 rows in set (0.06 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.05 sec) mysql> GRANT ALL PRIVILEGES ON algoritma_DB.* TO 'algoritma_dbadmin@localhost' IDENTIFIED BY "h3F!jz?Z" WITH GRANT OPTION; ERROR 1047: Unknown command mysql> |
Double quotes around the password?
This is what I use (recently tested on version 5.0.37 but as far as I know it also works on 4.0.23a) Code:
mysql> grant all privileges on *.* to 'wim'@'localhost' identified by 'my password' with grant option; Code:
GRANT ALL ON mydb.mytbl TO 'someuser'@'somehost'; Note: check your documentation |
Yeah single quotes for the passwd, precisely because it allows 'funny' chars in a passwd. Also, separate sets of quotes for user and host.
IOW, what he said :) |
All times are GMT -5. The time now is 10:54 PM. |