On Sun, 16 Apr 2017 20:45:56 +0100 Joe <j...@jretrading.com> wrote: > On Sun, 16 Apr 2017 10:17:53 +0100 > Abdelkader Belahcene <abelahc...@gmail.com> wrote: > > > *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 <http://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 r...@lite.umbb.dz > > <r...@lite.umbb.dz> -p* > > *Enter password: * > > *ERROR 1045 (28000): Access denied for user 'r...@lite.umbb.dz > > <r...@lite.umbb.dz>'@'localhost' (using password: YES)* > > *Thanks a lot* > > As deloptes said, the issue is in mysql permissions. I said a week > ago: > > "If it is a problem with mysql account privileges, then change them. > > Mysql user privileges depend on the name of the user and the name of > the machine the user is connecting *from*. The name of the machine > that mysql is running on is irrelevant, and would be needed only when > setting up the connection on the remote machine using the mysql > server's hostname." > > Wordpress will have created a user in the mysql privileges table, with > (theoretically) exactly the correct access permissions. But the user > is named 'xxxx@localhost'. The best way to proceed is to create > another user with exactly the same privileges, and exactly the same
> 'xxxx', but '@<name or IP address of the mysql server>'. So for Sorry, of course, that should be 'of the Wordpress server'. Not awake this evening. > example the new user is 'xxxx@12.34.45.67'. > > What are you using to administer mysql? If a GUI-based method, such as > phpmyadmin, then open it on the whole installation, and look at the > Privileges tab for the user list, where you will find the user that > Wordpress has created. Then within the 'mysql' database, look at the > 'db' table for detailed privileges. If you have no explicit mysql > administration utility, then use the built-in command line mysql > interface. > > I am deliberately not being more specific, as if you are using mysql > or any other database, even just as an accessory to another > application, you cannot avoid acquiring at least a basic > understanding of administration, if only to avoid problems like the > one you currently have. >