Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #179944 > unrolled thread

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

Back to article view | Back to linux.debian.user

Contents

  how to force mysql to use the name of my machine instead of localhost Abdelkader Belahcene <abelahcene@gmail.com> - 2017-04-10 09:00 +0200
    Re: how to force mysql to use the name of my machine instead of  localhost Joe <joe@jretrading.com> - 2017-04-10 09:40 +0200

#179944 — how to force mysql to use the name of my machine instead of localhost

[Multipart message — attachments visible in raw view] — view raw

My  machine  has another name than localhost like lite.bela.umbb,
when I install mysql, it always takes the the localhost as the name of the
machine. this yields in a problem for me, when I use for example wordpress
and I want a remote connection.  because the localhost stored in DB is
irrelevant from a remote machine.

The question is : how to force mysql to use the name of my machine instead
of localhost  for mysql server

Thanks a lot
Regards

[toc] | [next] | [standalone]

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

On Mon, 10 Apr 2017 07:51:56 +0100
Abdelkader Belahcene <abelahcene@gmail.com> wrote:

> My  machine  has another name than localhost like lite.bela.umbb,
> when I install mysql, it always takes the the localhost as the name
> of the machine. this yields in a problem for me, when I use for
> example wordpress and I want a remote connection.  because the
> localhost stored in DB is irrelevant from a remote machine.
> 
> The question is : how to force mysql to use the name of my machine
> instead of localhost  for mysql server
> 

Mysql does not have or need a machine name. What problem are you having?
What are you trying to do and what error messages are you getting?

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.

-- 
Joe

[toc] | [prev] | [standalone]

Back to top | Article view | linux.debian.user

csiph-web