Geek Answers Handbook

Mysql and Putty - ERROR 1044 (42000): access denied for user

Im pretty new in mysql at the command line level. unfortunately, the destination I set means that I have to use the command line. I access the school server through PuTTY. log on no problems their type is mysql -p, log in fine, but then when I go to create the database, I get error 1044. I also tried root, but no luck.

login as: 10081552
Using keyboard-interactive authentication.
Password:
Last login: Sat Dec  7 16:04:24 GMT 2013 from 90.218.202.89 on ssh
Last login: Sat Dec  7 16:04:29 2013 from 90.218.202.89
10081552@sots ~ $ mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8636
Server version: 5.0.90-log Gentoo Linux mysql-5.0.90-r2

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database hello;
 ERROR 1044 (42000): Access denied for user '10081552'@'localhost' to database 'hello'
mysql>

I checked the privileges and they seem perfect (I think)

mysql> show grants;

| Grants for 10081552@localhost                                                                                                            

 GRANT USAGE ON *.* TO '10081552'@'localhost' IDENTIFIED BY PASSWORD '*removed the  hash'                     |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, LOCK TABLES ON `10081552`.* TO '10081552'@'localhost' |

2 rows in set (0.00 sec)

mysql>

so I am sure that this is what I am doing wrong, but can someone tell me why I can’t create anything. as i said before, i'm new to the command line but not mysql or databases at all.

+4
2

,

, . GRANT 10081552@localhost , 10081552

GRANT ... ON `10081552`.* TO '10081552'@'localhost' 
             ^^^^^^^^^^^^

, .

CREATE TABLE hello_world(id INT);

.

+2

, root

0

More articles:


All Articles