. (That was an interesting three-day exercise in itself, but it's finally working.) As part of
doing that, the location of the mysqld socket changed, but I changed that in /etc/my.conf and in
/etc/php.ini, in three places. I Read The Fine Manual, and I know that to MySQL, localhost
actually means
in
itself, but it's finally working.) As part of doing that, the location of the
mysqld socket changed, but I changed that in /etc/my.conf and in /etc/php.ini,
in three places. I Read The Fine Manual, and I know that to MySQL, localhost
actually means socket, rather than 127.0.0.1. So I changed /etc
I have ran the following to test a fix for an app issue :
delete from mysql.user where user='';
2lines got effected
after this I can´t connect through command line anymore :
./mysqladmin -u root password pwd
I get access denied for user 'root'@'localhost (using password:'NO')
how can I
'@'localhost (using password:'NO')
your command line is plain wrong
as you can see in the response you are *not* using a password
./mysqladmin -u root --password=pwd
*don't do that at all* your password ends in the history
./mysqladmin -u root -p
after that you get a pwd-prompt
how can I restore
='';
2lines got effected
after this I can´t connect through command line anymore :
./mysqladmin -u root password pwd
I get access denied for user 'root'@'localhost (using password:'NO')
how can I restore the db so I can connect through command line again ?
thks
Hi
thanks but it is not working either
I wonder if the 2 rows I removed (with empty users for localhost and my
computer names) were responsilbe for allowing the autentication ?
how this table works ?
what mysql checks on it ? the pwd column ? if it is filled ?
what if I have 2 records
='';
2lines got effected
after this I can´t connect through command line anymore :
./mysqladmin -u root password pwd
I get access denied for user 'root'@'localhost (using password:'NO')
your command line is plain wrong
as you can see in the response you are *not* using a password
effected
after this I can´t connect through command line anymore :
./mysqladmin -u root password pwd
I get access denied for user 'root'@'localhost (using password:'NO')
your command line is plain wrong
as you can see in the response you are *not* using a password
./mysqladmin -u root --password
'@'localhost (using password:'NO')
how can I restore the db so I can connect through command line again ?
thks
What that tells me is that you were never actually logging in as root
but the system was authenticating you as the 'anonymous' user. Quoting
from the very fine manual:
http
I am really sorry about this one ..
the connection is ok ...
I had not checked that I was using mysqladmin instead of mysql
now please how can I check what is wrong with my application ( My SQL Admin
)
at its login page it asks for user / pwd / server and db
using both localhost and 127.0.01
/ server and db
using both localhost and 127.0.01 ... it gets the same error :
access denied for user 'root'@'localhost'
the app has a php config page where it fills these info
I am able to connect to it manually too using :
./mysql -h localhost -u root -pmy_pwd mysql-admin
but the app
1500
ether 00:02:55:11:19:76
media: 1000baseT (unknown type)
=
mac:bin ericomtx$ nslookup localhost
;; connection timed out; no servers could be reached
Hi
| | ericomtxmacbookpro.local |
*E85DC00A0137C6171923BE35EDD809573FB3AB4F |
mysql DELETE FROM mysql.user WHERE user='';
mysql FLUSH PRIVILEGES;
maybe helps?
Cheers
--
Claudio
|
+--+--+---+
| root | localhost|
*E85DC00A0137C6171923BE35EDD809573FB3AB4F |
| root | ericomtxmacbookpro.local |
*E85DC00A0137C6171923BE35EDD809573FB3AB4F |
| root | 127.0.0.1|
*E85DC00A0137C6171923BE35EDD809573FB3AB4F
the current input
statement.
mysql
...
but in the browser I get the error :
Access denied for user 'root'@'localhost' (using password: YES)
I can't find any information in error log and access log
is there any command parameter that I should use when starting mysql so
this doesn't happen ?
I
the error :
Access denied for user 'root'@'localhost' (using password: YES)
I can't find any information in error log and access log
is there any command parameter that I should use when starting mysql so
this doesn't happen?
are you using localhost or 127.0.0.1 in the web-application
root
From that error I would suspect you are trying to access to a database
where has not external access. And yeah, try by doing
$ mysql -u root -p database -h localhost -P 3306
change localhost by 127.0.0.1 in order to test if both cases work, and
see which of them (localhost/127.0.0.1) is defined
using both urls I get the same error :
http://localhost/mysql/index.php
http://127.0.0.1/mysql/index.php
in 127.0.0.1... after I submit the index.php ... it redirects to localhost
too ..
2014/1/13 Reindl Harald h.rei...@thelounge.net
Am 13.01.2014 18:28, schrieb Érico
using localhost the coonection works ...
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h
localhost -P 3306
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL
2014 12:57, Érico erico...@gmail.com wrote:
using localhost the coonection works ...
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h localhost
-P 3306
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get
not be the best solution, it's just to skip it,
you must look at the query/connection on your php file.
On 13 January 2014 12:57, Érico erico...@gmail.com wrote:
using localhost the coonection works ...
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h localhost
-P 3306
the granting is not affecting the tables:
mysql grant all privileges on *.* to root@localhost identified by 'pwd';
Query OK, 0 rows affected (0.00 sec)
mysql FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
...
and if I try the granting in 127.0.0.1 :
mysql grant all privileges
On 13 January 2014 13:25, Érico erico...@gmail.com wrote:
the granting is not affecting the tables:
mysql grant all privileges on *.* to root@localhost identified by 'pwd';
Query OK, 0 rows affected (0.00 sec)
mysql FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
...
and if I try
Hi
didn't work
look ... isn't this something related to this :
are you using localhost or 127.0.0.1 in the web-application
root@localhost != root@127.0.0.1 = different users
localhost: Unix-Socket
127.0.0.1: TCP
...
since I am not able to stabilsh a connection even with using eclipse ...
my
Hello Érico,
On 1/13/2014 1:49 PM, Érico wrote:
Hi
didn't work
look ... isn't this something related to this :
are you using localhost or 127.0.0.1 in the web-application
root@localhost != root@127.0.0.1 = different users
localhost: Unix-Socket
127.0.0.1: TCP
...
since I am not able
not connect through
command line
Thks
2014/1/13 shawn l.green shawn.l.gr...@oracle.com
Hello Érico,
On 1/13/2014 1:49 PM, Érico wrote:
Hi
didn't work
look ... isn't this something related to this :
are you using localhost or 127.0.0.1 in the web-application
root@localhost != root@127.0.0.1
WTF - we are talking about *database connections* and *not* http-URL's
the webserver is only the *messenger*
Am 13.01.2014 18:54, schrieb Érico:
using both urls I get the same error :
http://localhost/mysql/index.php
http://127.0.0.1/mysql/index.php
in 127.0.0.1... after I submit
*your application* is connecting to mysql
*your application* is using a hostname
*your application* *may* use 127.0.0.1
*your application* should use localhost to *connect to the databse*
*your application* can only use TCP *if there is* a *mysql user* with *that
host*
http://dev.mysql.com/doc
Hello Reindl,
On 1/13/2014 3:01 PM, Reindl Harald wrote:
*your application* is connecting to mysql
*your application* is using a hostname
*your application* *may* use 127.0.0.1
*your application* should use localhost to *connect to the databse*
*your application* can only use TCP
provide the output of the below query.
Select user, host, password from mysql.user;
Thanks
Vikas Shukla
Mail Sent from my Windows Phone From: Reindl Harald
Sent: =E2=80=8E14-=E2=80=8E01-=E2=80=8E2014 01:38
To: mysql@lists.mysql.com
Subject: Re: Access denied for user 'root'@'localhost' (using
Am 13.01.2014 21:47, schrieb shawn l.green:
Hello Reindl,
We are not saying he is using HTTP commands to log into his database
we excludes obviously the OP or his overall understanding :-)
Am 13.01.2014 18:54, schrieb Érico:
using both urls I get the same error :
http://localhost/mysql
Hello John,
On 9/2/2013 12:49 AM, John Smith wrote:
On Sun, 1/9/13, Reindl Harald h.rei...@thelounge.net wrote:
Subject: Re: Can't Connect Localhost
To: mysql@lists.mysql.com
Date: Sunday, 1 September, 2013, 2:44 PM
I looked
2013/09/02 12:49 +0800, John Smith
I looked in mysql.config.pl and no localhost :(
mysql.config.pl from what software damned?
mysql.config.pl does not exist in context of mysql
It exists in the following folder on my Win8 box:
/Program Files (x86)/MySQL/MySQL Server 5.5/bin
Yes
__mysql_exceptions,OperationalError (2003 Can't connect to MySQL server on
'localhost' (10061))
My question: How do I change from localhost to 124.0.0.1?
TIA
John
On Sun, 1/9/13, Terry J Fundak te...@tjsoftworks.com wrote:
Subject: Re: Can't
01.09.2013 13:56, schrieb John Smith:
__mysql_exceptions,OperationalError (2003 Can't connect to MySQL server on
'localhost' (10061))
My question: How do I change from localhost to 124.0.0.1?
Hi John,
Starting over….
What is the error message?
On Aug 31, 2013, at 3:26 PM, John
On Sun, 1/9/13, Reindl Harald h.rei...@thelounge.net wrote:
Subject: Re: Can't Connect Localhost
To: mysql@lists.mysql.com
Date: Sunday, 1 September, 2013, 1:34 PM
where you can change this? typically
in the config file
of teh software without
Am 01.09.2013 15:37, schrieb John Smith:
On Sun, 1/9/13, Reindl Harald h.rei...@thelounge.net wrote:
Subject: Re: Can't Connect Localhost
To: mysql@lists.mysql.com
Date: Sunday, 1 September, 2013, 1:34 PM
where you can change
Try
mysql -u root -h 127.0.0.1 -p
And if that doesn't work
mysql -u root -h PC IP address -p
On Sep 1, 2013, at 4:59 AM, John Smith cantinaderecuer...@yahoo.com wrote:
__mysql_exceptions,OperationalError (2003 Can't connect to MySQL server on
'localhost' (10061))
My question: How do I
On Sun, 1/9/13, Reindl Harald h.rei...@thelounge.net wrote:
Subject: Re: Can't Connect Localhost
To: mysql@lists.mysql.com
Date: Sunday, 1 September, 2013, 2:44 PM
I looked in mysql.config.pl and no localhost :(
mysql.config.pl from what
Hi;
How do I change my connection from localhost to 127.0.0.1 on a Win8 machine?
TIA,
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Am 01.09.2013 00:26, schrieb John Smith:
How do I change my connection from localhost to 127.0.0.1 on a Win8 machine?
in which context?
mysql -h 127.0.0.1..
signature.asc
Description: OpenPGP digital signature
first: you not answer off-list on list-repsones
Am 01.09.2013 01:00, schrieb Terry J Fundak:
So... I guess I need to ask: Do you know that 127.0.0.1/localhost only refers
to the machine you are on, right?
naturally yes
One cannot, for example, attempt to login to a remote host with that IP
Am 01.09.2013 01:02, schrieb Terry J Fundak:
Also https://en.wikipedia.org/wiki/Localhost for move reading on the
subject
Sorry if I'm missing your issue
why do you think that i have any issue and why
do you insist to reply offlist?
On Aug 31, 2013, at 15:41, Reindl Harald
-Mail: te...@tjsoftworks.com
On Aug 31, 2013, at 3:26 PM, John Smith cantinaderecuer...@yahoo.com wrote:
Hi;
How do I change my connection from localhost to 127.0.0.1 on a Win8 machine?
TIA,
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
version there
is this extra line in the information_schema.USER_PRIVILEGES table:
| ''@'localhost' | NULL | USAGE
| NO |
(Note the null-string user prepended to @localhost)
Again: the functional, non-broken state does NOT have
!
On 26/12/12 18:00, Round Square wrote:
Hi all:
Suddenly, after a long, functioning run of the mysql server, all the
non-root accounts went bad, with:
Access denied for user 'non_root_user'@'localhost' (using
password: YES)
Authenticating with non_root_u
Hi all:
Suddenly, after a long, functioning run of the mysql server, all the non-root
accounts went bad, with:
Access denied for user 'non_root_user'@'localhost' (using password:
YES)
Authenticating with non_root_u...@server.ip.address still works ( the
bind-address in my.cnf
mysql user
On 26/12/12 18:00, Round Square wrote:
Hi all:
Suddenly, after a long, functioning run of the mysql server, all the non-root accounts went bad, with:
Access denied for user 'non_root_user'@'localhost' (using password:
YES)
Authenticating with non_root_u
i have given select/insert/update/delete rights to a user on a specific
database, from localhost. when i try to login to mysql using the uid, i get
error:
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
password: YES)
what other privilege do i need to give this user?
That says that your password in not correct. You have not gotten to specific
privileges.
Did you previously do
GRANT ... TO myuser@localhost IDENTFIED BY '...';
?
If you can get in via root, do
SHOW GRANTS FOR myuser@localhost;
SELECT * FROM mysql.user WHERE user = 'myuser';
-Original
On Mon, Sep 24, 2012 at 1:55 PM, Rajeev Prasad rp.ne...@yahoo.com wrote:
i have given select/insert/update/delete rights to a user on a specific
database, from localhost. when i try to login to mysql using the uid, i get
error:
ERROR 1045 (28000): Access denied for user 'myuser
Also ensure you issue: FLUSH PRIVILEGES; after making any changes to
permissions..
On 24 September 2012 20:09, Rick James rja...@yahoo-inc.com wrote:
That says that your password in not correct. You have not gotten to specific
privileges.
Did you previously do
GRANT ... TO myuser@localhost
this is what i see:
| GRANT USAGE ON *.* TO 'myuser'@'localhost' IDENTIFIED BY PASSWORD
'*829E20779862ACF47E2B4D9B7C6B1B1B1ADF7925' |
| GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON `mydatabase`.* TO
'myuser'@'localhost
|
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--+--++-+--+---+-+-+--+
| localhost
, 2012 4:11 PM
Subject: Re: user not able to login from localhost
mysql SELECT * FROM mysql.user WHERE user ='myuser
end with ; or \g.
mysql show tables;
ERROR 1046 (3D000): No database selected
mysql quit
Bye
$ mysql -u dummy -p (when I type a real password : dummy, YES... or anything
else)
ERROR 1045 (28000): Access denied for user 'dummy'@'localhost' (using password:
YES) $ mysqladmin -u dummy version (try
Am 18.11.2011 23:16, schrieb Franck Houssen:
$ mysql -u dummy -p (when I type a real password : dummy, YES... or anything
else)
ERROR 1045 (28000): Access denied for user 'dummy'@'localhost' (using
password: YES)
and if you submit the same post every day you will get the same anser
): No database selected
mysql quit
Bye
$ mysql -u dummy -p (when I type a real password : dummy, YES... or
anything else)
ERROR 1045 (28000): Access denied for user 'dummy'@'localhost' (using
password: YES) $ mysqladmin -u dummy version (try without password = KO)
mysqladmin: connect to server
: dummy, YES... or
anything else)
ERROR 1045 (28000): Access denied for user 'dummy'@'localhost' (using
password: YES) $ mysqladmin -u dummy version (try without password = KO)
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp
mysql quit
Bye
$ mysql -u dummy -p (when I type a real password : dummy, YES... or anything
else)
ERROR 1045 (28000): Access denied for user 'dummy'@'localhost' (using password:
YES) $ mysqladmin -u dummy version (try without password = KO)
mysqladmin: connect to server at 'localhost' failed
(when I type a real password : dummy, YES... or anything
else)
ERROR 1045 (28000): Access denied for user 'dummy'@'localhost' (using
password: YES) $
well this is not a connection problem
your permissions in the mysql-user-tables are wrong
remember that localhost is not the same as 127.0.0.1
hi,
this surely is a beginners question:
i already created a user and privileges like this:
GRANT ALL PRIVILEGES ON `xxx`.* TO 'yyy'@'%' identified by 'zzz';
how do i modify this setup to remove access from localhost/127.0.0.1?
mysql version is 5.1.49
thx
matthias
--
MySQL General Mailing
from localhost/127.0.0.1?
mysql version is 5.1.49
thx
matthias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=sangpr...@gmail.com
Willy Mularto
F300HD+MR18DE (NLC1725)
--
MySQL General
and privileges like this:
GRANT ALL PRIVILEGES ON `xxx`.* TO 'yyy'@'%' identified by 'zzz';
how do i modify this setup to remove access from localhost/127.0.0.1?
mysql version is 5.1.49
thx
matthias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
and privileges like this:
GRANT ALL PRIVILEGES ON `xxx`.* TO 'yyy'@'%' identified by 'zzz';
how do i modify this setup to remove access from localhost/127.0.0.1?
mysql version is 5.1.49
thx
matthias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
does this mean that access from everywhere but localhost is impossible?
matthias
Am 2011-06-20 15:22, schrieb Andrew Moore:
Grant only to the hosts you want to have access to your data.
Andy
On 20 Jun 2011 14:20, Willy Mularto sangpr...@gmail.com
mailto:sangpr...@gmail.com wrote:
Replace
Nope, for example you can assign access to db1.* to user1@192.168.% which
doesn't include localhost or 127.0.0.1.
On 20 Jun 2011 14:35, Matthias Leopold matth...@aic.at wrote:
does this mean that access from everywhere but localhost is impossible?
matthias
Am 2011-06-20 15:22, schrieb Andrew
MySQL works on a ALLOW scheme, and since % contains all you need to specify
a more specific 'rule'.
you can use this dirty trick:
GRANT USAGE ON `xxx`.* TO 'yyy'@'127.0.0.1' identified by
'impossible-password';
GRANT USAGE ON `xxx`.* TO 'yyy'@'localhost' identified by
'impossible-password
I haven't bothered to look for the bug, but it seems to me to be quite
reasonable default behaviour to lock the whole lot when you're dumping
transactional tables - it ensures you dump all tables from the same consistent
view.
I would rather take this up with the ZRM people - it should just
On Mon, 06 Jun 2011 12:44 +0200, Johan De Meersman
vegiv...@tuxera.be wrote:
I haven't bothered to look for the bug, but it seems to me to be quite
reasonable default behaviour to lock the whole lot when you're dumping
transactional tables - it ensures you dump all tables from the same
- Original Message -
From: ag...@airpost.net
Excluding 'performance_schema' appears to eliminate the error. And it
seems does NOT cause a reliability-of-the-backup problem.
Hah, no, backing that up is utterly pointless. Never noticed it doing that.
It's basically a virtual schema
On Mon, 06 Jun 2011 18:54 +0200, Johan De Meersman
vegiv...@tuxera.be wrote:
Excluding 'performance_schema' appears to eliminate the error. And it
seems does NOT cause a reliability-of-the-backup problem.
Hah, no, backing that up is utterly pointless.
that's a useful/final confirmation.
of that backup cmd, i see an ERROR @ console,
...
manual:backup:INFO: PHASE START: Creating raw backup
manual:backup:INFO: Command used for raw backup is
/usr/share/mysql-zrm/plugins/socket-copy.pl
--mysqlhotcopy=/usr/bin --host=localhost --port=3306
: Creating raw backup
manual:backup:INFO: Command used for raw backup is
/usr/share/mysql-zrm/plugins/socket-copy.pl
--mysqlhotcopy=/usr/bin --host=localhost --port=3306
--socket=/var/cache/mysql/mysql.sock --quiet mysql
/var/mysql-bkup/manual/20110605131003
/var
hi,
On Sun, 05 Jun 2011 22:24 +0200, Reindl Harald
h.rei...@thelounge.net wrote:
have you checked you permissions-table if all privileges are active for root
i've got,
mysql show grants for 'root'@'localhost
|
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+
| localhost
|
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+
| localhost
|
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+
| localhost
|
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---+
| localhost
On Sun, 05 Jun 2011 23:30 +0200, Reindl Harald
h.rei...@thelounge.net wrote:
BTW
WHY is everybody ansering to the list AND the author of the last post?
this reults in get every message twice :-(
Reply - sends to ONLY the From == h.rei...@thelounge.net
Reply to all sends to BOTH the From ==
On Sun, 05 Jun 2011 23:29 +0200, Reindl Harald
h.rei...@thelounge.net wrote:
i would use a replication slave and stop him for consistent backups
because dumb locks are not really a good solution independent
if this works normally
unfortunately, i have no idea what that means.
something's
Am 05.06.2011 23:49, schrieb ag...@airpost.net:
On Sun, 05 Jun 2011 23:29 +0200, Reindl Harald
h.rei...@thelounge.net wrote:
i would use a replication slave and stop him for consistent backups
because dumb locks are not really a good solution independent
if this works normally
i still have no idea why this is necessary.
there seems to be a but, problem, misconfiguration, etc.
wouldn't it make some sense to try to FIX it, rather than setting up a
completely different server?
perhaps someone with an idea of the problem and its solution will be
able to chime in.
--
Am 05.06.2011 23:55, schrieb ag...@airpost.net:
i still have no idea why this is necessary.
take it or not
it is a professional solution which works for
databses with 20 GB every day here with rsync
without interrupt/lock mysqld a second
and it is much faster
there seems to be a but,
-Original Message-
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Thursday, November 25, 2010 3:29 AM
To: Jerry Schwartz
Cc: Brent Clark; mysql mailing list
Subject: Re: localhost vs domain for connection string
On Wed, Nov 24, 2010 at 4:44 PM
On Wed, Nov 24, 2010 at 4:44 PM, Jerry Schwartz je...@gii.co.jp wrote:
[JS] This might or might not be enabled by default. I'm running on Windows,
and I seem to remember having to change it.
# Enable named pipe, bypassing the network stack
enable-named-pipe
Windows' named pipes are not the
-Original Message-
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Wednesday, November 24, 2010 2:39 AM
To: Jerry Schwartz
Cc: Brent Clark; mysql mailing list
Subject: Re: localhost vs domain for connection string
On Tue, Nov 23, 2010 at 7:55 PM
Hiya
Is there a difference if someone had to make the connection string the a
domain (hosts file entry makes the machine look at its ip) as opposed to
just using localhost.
If so would a performance hit be incurred?
I have this client that has used the domain and in netstat im seeing
all
IIRC, localhost is seen by the client as a magic word to mean use the
UNIX socket, not 127.0.0.1.
So, yes, that would make the connection not show up in netstat :-)
On Tue, Nov 23, 2010 at 11:11 AM, Brent Clark brentgclarkl...@gmail.comwrote:
Hiya
Is there a difference if someone had to make
From: Brent Clark brentgclarkl...@gmail.com
Is there a difference if someone had to make the connection string the a
domain (hosts file entry makes the machine look at its ip) as opposed to just
using localhost.
If so would a performance hit be incurred?
Using 'localhost' will always
-Original Message-
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Tuesday, November 23, 2010 6:19 AM
To: Brent Clark
Cc: mysql mailing list
Subject: Re: localhost vs domain for connection string
IIRC, localhost is seen by the client as a magic
On Tue, Nov 23, 2010 at 7:55 PM, Jerry Schwartz je...@gii.co.jp wrote:
IIRC, localhost is seen by the client as a magic word to mean use the
UNIX socket, not 127.0.0.1.
[JS] IF it is enabled in my.cnf.
Hmm, didn't know that bit. What's the option called ?
--
Bier met grenadyn
Is als
Hello,
We are experience an estrange problem with mysql and we need help to debug
this properly.
We have a mysql server 5.0.67 on a ubuntu intrepid.
Sometimes we have one unique query that cannot be executed and we get this
error:
SELECT command denied to user 'user'@'localhost' for table
hi,
I need some urgent help. We have encountered a problem, when we try to connect
in shell with a mysql client to the mysqld (via socket or via localhost). The
connection takes 5 to 50 seconds, or it happens that the connection is fast,
but then the use somethingdb; needs 5 to 50 seconds.
We
with a mysql client to the mysqld (via socket or via
localhost). The connection takes 5 to 50 seconds, or it happens that the
connection is fast, but then the use somethingdb; needs 5 to 50 seconds.
We have tried to use some advice from here already:
http://www.debianhelp.co.uk
at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
How can I correct this?
Is this because of a firewall preventing access to port 3306?If a firewall
is preventing access how was it able to ask for the password?
I have Nortan Internet Security trial
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
How can I correct this?
Is this because of a firewall preventing access to port 3306?If a firewall
is preventing access how was it able to ask for the password?
I have Nortan
the command line
and ran the command mysqladmin -p root shutdown next the root password was
asked for,I entered the correct password, when I entered the password the
below displayed error was the result
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC
entered the correct password, when I entered the password the
below displayed error was the result
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
How can I correct this?
Is this because of a firewall preventing
at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
How can I correct this?
Is this because of a firewall preventing access to port 3306?If a
firewall
is preventing access how was it able to ask for the password?
I have Nortan Internet
1 - 100 of 416 matches
Mail list logo