Web lists-archives.com

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




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@xxxxxxxxxxxx -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root@xxxxxxxxxxxx'@'localhost' (using password: YES)
Thanks a lot