0.1, via
MacPorts. (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, &quo
ee-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 "socket
/ 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 -p mysql-admi
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
user 'root'@'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'
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
>>>
>
here user='';
> > 2lines got effected
> >
> > after this I can´t connect through command line anymore :
> >
> > ./mysqladmin -u root password
> >
> > I get access denied for user 'root'@'localhost" (using password:'NO&#
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 for
#x27;;
> 2lines got effected
>
> after this I can´t connect through command line anymore :
>
> ./mysqladmin -u root password
>
> 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
>
>
> 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=
*don't do that at all* your password ends in the hi
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
I get access denied for user 'root'@'localhost" (using pas
her c8:2a:14:1a:47:ea
media: autoselect (none)
status: inactive
wc2: flags=822 mtu 1500
ether 00:02:55:11:19:76
media: 1000baseT ()
=
mac:bin ericomtx$ nslookup localhost
;; connection timed out; no servers co
Hi
> > > | | ericomtxmacbookpro.local |
> > *E85DC00A0137C6171923BE35EDD809573FB3AB4F |
> > >
>
mysql> DELETE FROM mysql.user WHERE user='';
mysql> FLUSH PRIVILEGES;
maybe helps?
Cheers
--
Claudio
+
> > | user | host | password
> |
> >
> +--+--+---+
> > | root | localhost|
> *E85DC00A0137C6171923BE35EDD809573FB3AB4F |
> > | root | ericomtx
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 :
>
> h
fer-Encoding: quoted-printable
Please 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 den
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 *if there is
*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
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.
connect through
command line
Thks
2014/1/13 shawn l.green
> 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&qu
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:
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 conn
On 13 January 2014 13:25, Érico 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
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> gran
ileges;
>
> Of course this could 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 wrote:
>> using localhost the coonection works ...
>> ericomtxmacbookpro:bin ericomtx$ ./mysql -u
ur php file.
On 13 January 2014 12:57, Érico 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 ca
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
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
>
>
> Am 13.01.2014 18:28, schrieb Érico:
> > ericomtxmacbookp
>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 -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 defi
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
> thi
. Type '\c' to clear 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 th
>>>> 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 f
Hello John,
On 9/2/2013 12:49 AM, John Smith wrote:
On Sun, 1/9/13, Reindl Harald 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 "
On Sun, 1/9/13, Reindl Harald 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.
Try
mysql -u root -h 127.0.0.1 -p
And if that doesn't work
mysql -u root -h -p
On Sep 1, 2013, at 4:59 AM, "John Smith" wrote:
> __mysql_exceptions,OperationalError (2003 "Can't connect to MySQL server on
> 'localhost' (10061)")
>
> My q
Am 01.09.2013 15:37, schrieb John Smith:
>
> On Sun, 1/9/13, Reindl Harald wrote:
>
> Subject: Re: Can't Connect Localhost
> To: mysql@lists.mysql.com
> Date: Sunday, 1 September, 2013, 1:34 PM
>
> where you can
On Sun, 1/9/13, Reindl Harald 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 crystal balls we
e
Am 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….
>
&
__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 wrote:
Subject: Re: Ca
-1000 Cell
e-Mail: te...@tjsoftworks.com
On Aug 31, 2013, at 3:26 PM, John Smith 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.c
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
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
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
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
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-b
that might call for that?
Thanks!
>
>
>
>
>
> 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 &#
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)
Authenticat
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
localhost
mysql> SELECT * FROM mysql.user WHERE user =
r_connections |
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--+--++-+--+---+-+-+--
this is what i see:
| GRANT USAGE ON *.* TO 'myuser'@'localhost' IDENTIFIED BY PASSWORD
'*829E20779862ACF47E2B4D9B7C6B1B1B1ADF7925' |
| GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON `mydatab
Also ensure you issue: FLUSH PRIVILEGES; after making any changes to
permissions..
On 24 September 2012 20:09, Rick James wrote:
> That says that your password in not correct. You have not gotten to specific
> privileges.
>
> Did you previously do
> GRANT ... TO myuser@localho
On Mon, Sep 24, 2012 at 1:55 PM, Rajeev Prasad 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 '
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
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?
>>
>> Version: '5.5.17' socket: '/tmp/mysql.sock' port: 3306 Source
>> distribution
>>
>>
>>
>> $ ll /tmp (check: mysql.sock is created and can be accessed - read / write
>> permissions)
>>
>> total 13
>>
v 14 12:15 mysql.sock
>
>
>
> $ ps (check: server launched OK)
>
> PIDPPIDPGID WINPID TTY UIDSTIME COMMAND
>
> 472034004720 6576 con 1000 12:15:53
> /usr/local/mysql/bin/mysqld
>
> $ mysql -u dummy -p (when I hit "retu
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
3
/usr/local/mysql/bin/mysqld
$ mysql -u dummy -p (when I hit "return" as a password => connection OK)
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
mysql> show tables;
ERROR 1046 (3D000): No database selected
mysql> quit
Bye
$ mysql -u du
t; 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) $
well this is not a connection problem
your permissio
t; connection OK)
Enter password:
Welcome to the MySQL monitor. Commands 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
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&#x
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" wrote:
> does this mean that "access from everywhere but localhost" is impossible?
>
> matthias
>
> A
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" mailto:sangpr...@gmail.com>> wr
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
s 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 ve
'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:
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
matth
On Mon, 06 Jun 2011 18:54 +0200, "Johan De Meersman"
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. thx.
> No,
- 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 schem
On Mon, 06 Jun 2011 12:44 +0200, "Johan De Meersman"
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
> consistent vi
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
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, prob
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.
--
My
Am 05.06.2011 23:49, schrieb ag...@airpost.net:
>
> On Sun, 05 Jun 2011 23:29 +0200, "Reindl Harald"
> 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
On Sun, 05 Jun 2011 23:29 +0200, "Reindl Harald"
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 apparently broken w
On Sun, 05 Jun 2011 23:30 +0200, "Reindl Harald"
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 == h.rei...@thelounge.n
ce_priv | ssl_type | ssl_cipher |
> x509_issuer | x509_subject | max_questions | max_updates |
> max_connections | max_user_connections | plugin | authentication_string
> |
> +---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--+----
e_tablespace_priv | ssl_type | ssl_cipher |
> x509_issuer | x509_subject | max_questions | max_updates |
> max_connections | max_user_connections | plugin | authentication_string
> |
> +---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--+--
s | max_user_connections | plugin | authentication_string
|
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+---
cation_string |
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--++--++-+--+---+-+-+--++---
hi,
On Sun, 05 Jun 2011 22:24 +0200, "Reindl Harald"
wrote:
> have you checked you permissions-table if all privileges are active for root
i've got,
mysql> show grants
OR @ 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&
xec 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"
>-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
>
&g
On Wed, Nov 24, 2010 at 4:44 PM, Jerry Schwartz 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 same as u
>-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, Jerry Schwartz 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
>-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, "loc
> From: Brent Clark
>
> 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' wil
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 wrote:
> Hiya
>
> Is there a difference if someo
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
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'@'local
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.
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
;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: 'Acc
sword 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'@'localhost' (using pa
utdown MySQL service from 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'
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 access to port 3306?If a firewall
is preventing access how w
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 th
1 - 100 of 429 matches
Mail list logo
