Re: Re: how to force mysql to use the name of my machine instead of localhost

[Abdelkader Belahcene <abelahcene@gmail.com>]

Thanks for reply and links

But I am sure, the problem is in mysql.

Look at this: 

my count is lite@lite

and hostname  gives 

lite@lite:/opt/lampp$ hostname

lite.umbb.dz

bin/mysql

ERROR 1045 (28000): Acces s denied for user 'lite'@'localhost' (using password: YES)

Here it tries to connect as 'lite'@'localhost', I am not  'lite'@'localhost', but lite@lite

then  same thing as root, even if use -h option : 

lite@lite:/opt/lampp$ bin/mysql -u root -h lite

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

I tried  again, using the complete name, it adds localhost!!!!

 

lite@lite:/opt/lampp$ bin/mysql -u root@lite.umbb.dz -p

Enter password: 

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

Thanks a lot