Re: how to force mysql to use the name of my machine instead of localhost
On Sun, 16 Apr 2017 20:45:56 +0100
Joe <joe@jretrading.com> wrote:
> On Sun, 16 Apr 2017 10:17:53 +0100
> Abdelkader Belahcene <abelahcene@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 root@lite.umbb.dz
> > <root@lite.umbb.dz> -p*
> > *Enter password: *
> > *ERROR 1045 (28000): Access denied for user 'root@lite.umbb.dz
> > <root@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.
>
Reply to: