[Problem] mysql

[Adiros]

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

 

dodam ze mysql -p uzywalem zeby stworzyc userow itd a teraz jak wpisuje i wpisuje haslo prawidlowe to ten komunikat wyzej wyskakuje a jak odpalam server to:

 

 

 

HOSTNAME: channel99(i te inne tez)

mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)

cannot open direct sql connection to host: localhost user: mt2 db: common

cannot start server while no common sql connected

 

 

mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)

failed, retrying in 5 seconds

[matuszny1987]

Stworzyłeś usera "mt2" z hasłem "mt2!@#" ?

[bfffff]

Ej a co to ma do tego?

[michal3433]

wpisz :

 

mysql -p

 

[wpisz hasło]

 

 

CREATE USER 'mt2'@'%' IDENTIFIED BY 'mt2!@#'; [ENTER]

 

GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'%' WITH GRANT OPTION; [ENTER]

 

quit

 

I bedzie śmigało