[SOLVED] can't connect to mysql server

rhklinux · 08-06-2010, 05:56 AM

hi

i want to learn mysql !!
i have a pc with no lan/wan connections (i mean no server-client relation)
i installed mysql using synaptic , when it was installing mysql,it asked me for password (opened a window) .
then i typed in terminal

mysql --user=username

output is :

ERROR 1045 (28000): Access denied for user 'rohit'@'localhost' (using password: NO)

i am a complete newbie so plz give step by step advice ,
thanks in advance

sem007 · 08-06-2010, 06:47 AM

use -p option with mysql command

Code:

mysql -uusername -p

for exa.
mysql -uroot -p

linuxlover.chaitanya · 08-06-2010, 06:56 AM

Have you set that user in mysql? MySQL users differ from the system users. By default you can login to mysql using root, create mysql user called rohit with whatever password you desire, give appropriate permissions and then use it.

rhklinux · 08-06-2010, 08:23 AM

thanks you both , -p had done its work, i will try the 2nd reply too