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
Am 29.05.2014 20:22, schrieb Érico:
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
='';
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
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 restore the db so I can connect
='';
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
Hello Érico
On 5/29/2014 2:22 PM, Érico wrote:
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
... 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 keeps geting the access denied error
would
/ 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
): Access denied for user 'hadoopuser'@'localhost'
(using password: YES)
---
Confidentiality Notice: The information contained in this e-mail and any
accompanying attachment(s)
is intended only
;
Query OK, 0 rows affected (0.00 sec)
mysql quit;
Bye
Then I use hadoopuser with password 123456
[hadoop@master ~]$ mysql -u hadoopuser -p
Enter password:
ERROR 1045 (28000): Access denied for user 'hadoopuser'@'localhost'
(using password: YES)
Hello,
I assume MySQL is listening
Am 05.05.2014 08:34, schrieb Manuel Arostegui:
% doesn't match localhost so if you don't specify it you will be
attempting to connect via Unix Socket.
If you don't want to specify -hlocalhost all the time, just do the grant
with @localhost instead of @%
nonsense
% matches *any host*
2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net:
Am 05.05.2014 08:34, schrieb Manuel Arostegui:
% doesn't match localhost so if you don't specify it you will be
attempting to connect via Unix Socket.
If you don't want to specify -hlocalhost all the time, just do the grant
Am 05.05.2014 10:19, schrieb Manuel Arostegui:
2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net
mailto:h.rei...@thelounge.net:
Am 05.05.2014 08:34, schrieb Manuel Arostegui:
% doesn't match localhost so if you don't specify it you will be
attempting to
.* to 'hadoopuser'@'%' identified by
'123456'; flush privileges;
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
mysql
# mysql -uhadoopuser -p123456
ERROR 1045 (28000): Access denied for user 'hadoopuser'@'localhost' (using
password: YES)
# mysql -uhadoopuser -p123456
Hi,
On 5-5-2014 10:57, Reindl Harald wrote:
Am 05.05.2014 10:19, schrieb Manuel Arostegui:
2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net
mailto:h.rei...@thelounge.net:
Am 05.05.2014 08:34, schrieb Manuel Arostegui:
% doesn't match localhost so if you don't
Am 05.05.2014 11:12, schrieb Jigal van Hemert:
On 5-5-2014 10:57, Reindl Harald wrote:
Am 05.05.2014 10:19, schrieb Manuel Arostegui:
2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net
mailto:h.rei...@thelounge.net:
Am 05.05.2014 08:34, schrieb Manuel Arostegui:
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
i know that, but it does not change the fact that here
Either you didn't know that but have trouble admitting it; or you did but
conciously chose to be rude and condescending instead of helpful.
Your choice. In the
Am 05.05.2014 15:26, schrieb Johan De Meersman:
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
i know that, but it does not change the fact that here
Either you didn't know that but have trouble admitting it; or you did but
conciously chose to be rude and
On 2014-05-04 9:17 PM, EdwardKing wrote:
I use mysql to create a database and grant rights to a user hadooptest,then I
use hadooptest to login mysql and use the database,but it failed. Why raise
error after I grant rights? How to solve it? Thanks.
The command sequence ...
mysql create
with password 123456
[hadoop@master ~]$ mysql -u hadoopuser -p
Enter password:
ERROR 1045 (28000): Access denied for user 'hadoopuser'@'localhost' (using
password: YES
| testuser | *FJHHEU5746DDHDUDYDH66488 |
+---++---+
and skip_networking is OFF
*Mysql Version : 5.1.58-log*
root@Serv1:~# mysql -utestuser -p@8AsnM0! -h $(hostname)
ERROR 1045 (28000): Access denied for user
ok
I have tried these :
ifconfig -a
lo0: flags=8049UP,LOOPBACK,RUNNING,MULTICAST mtu 16384
inet6 ::1 prefixlen 128
inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1
inet 127.0.0.1 netmask 0xff00
gif0: flags=8010POINTOPOINT,MULTICAST mtu 1280
stf0: flags=0 mtu 1280
fw0:
Hi
| | ericomtxmacbookpro.local |
*E85DC00A0137C6171923BE35EDD809573FB3AB4F |
mysql DELETE FROM mysql.user WHERE user='';
mysql FLUSH PRIVILEGES;
maybe helps?
Cheers
--
Claudio
connect through command line
what I can't do is :
1. connect or even ping inside eclipse using jconnector
2. connect from a php app (mysql adim) with or with out pwd ...
providing the error
Access denied for user 'root'@'localhost' (using password: YES)
Access denied
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
with ; or \g.
Your MySQL connection id is 31
Server version: 5.6.15 MySQL Community Server (GPL)
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
:
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 5.6.15 MySQL Community Server (GPL)
but in the browser I get the error :
Access denied for user 'root'@'localhost
monitor. Commands end with ; or \g.
Your MySQL connection id is 97
Server version: 5.6.15 MySQL Community Server (GPL)
but using 127.0.0.1 no :
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h
127.0.0.1 -P 3306
Enter password:
ERROR 1045 (28000): Access denied for user
password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
ericomtxmacbookpro:bin ericomtx$
2014/1/13 Erick Ocrospoma zipper1...@gmail.com
From that error I would suspect you are trying to access to a database
where has not external access. And yeah, try
)
but using 127.0.0.1 no :
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h 127.0.0.1
-P 3306
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
ericomtxmacbookpro:bin ericomtx$
2014/1/13 Erick Ocrospoma zipper1
the same error :
when pinging :
java.sql.SQLException: Access denied for user 'root'@'localhost' (using
password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237
' identified by kernel26' at line 1
It's my error :) It should be:
mysql grant all privileges on *.* to 'root'@'127.0.0.1' identified by
'kernel26';
...
in eclipse using jconnector ... I get the same error :
when pinging :
java.sql.SQLException: Access denied for user 'root'@'localhost' (using
error :) It should be:
mysql grant all privileges on *.* to 'root'@'127.0.0.1' identified by
'kernel26';
...
in eclipse using jconnector ... I get the same error :
when pinging :
java.sql.SQLException: Access denied for user 'root'@'localhost' (using
password: YES
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 to
Hi
no connections outside command line are being accepted . I have connected
through command line , but not using eclipse for example ... it gets the
same error from the web app
my apache and pages are in the same computer that mysql
I am not getting password issues.. otherwise I would not
id is 31
Server version: 5.6.15 MySQL Community Server (GPL)
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
*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*
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*
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 :
Hello Round,
On 12/27/2012 5:34 AM, Round Square wrote:
On 12/26/2012 01:25 PM, Igor Shevtsov wrote:
You mysql.user table might be corrupted.
If you have access to it as a root user, try check table mysql.user, and repair
table mysql.user if table corruption was detected.
Alternatively, shut
!
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'm trying to run mysql_upgrade but I get:
# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306'
'--socket=/var/run/mysqld/mysqld.sock'
mysqlcheck: Got error: 1045: Access denied for user 'root
I'm trying to run mysql_upgrade but I get:
# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306'
'--socket=/var/run/mysqld/mysqld.sock'
mysqlcheck: Got error: 1045: Access denied for user 'root
: Access denied for user 'root'@'localhost'
(using password: NO) when trying to connect
FATAL ERROR: Upgrade failed
I've also tried specifying my root password with --password and also
specifying -u mysql but it still fails with error 1045. My
/etc/passwd file looks like there is no password
I'm trying to run mysql_upgrade but I get:
# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306'
'--socket=/var/run/mysqld/mysqld.sock'
mysqlcheck: Got error: 1045: Access denied for user 'root
'mysqlcheck' with connection arguments: '--port=3306'
'--socket=/var/run/mysqld/mysqld.sock'
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost'
(using password: NO) when trying to connect
FATAL ERROR: Upgrade failed
I've also tried specifying my root password with --password
' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306'
'--socket=/var/run/mysqld/mysqld.sock'
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost'
(using password: NO) when trying to connect
FATAL ERROR: Upgrade failed
I've also tried specifying my root
: Access denied for user 'root'@'localhost'
(using password: NO) when trying to connect
FATAL ERROR: Upgrade failed
I've also tried specifying my root password with --password and also
specifying -u mysql but it still fails with error 1045. My
/etc/passwd file looks like there is no password for user
Hi,
¶¼ÊÇÖйúÈ˾Í˵ÖÐÎÄ°É^_^
Nice to meet you. But I think that this newsgroup is for the people who come
from all of the world. So post topics in English is better for anyone who is
also interested about this topic, right?
Ã÷Ìì»á¸üºÃ
I like this sentence.
\MySQL\MySQL Server 5.1\binmysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)'
--
Why do I get this result? Thanks.
Best Regards
Xiaoming
--
MySQL General Mailing List
For list
:
--
C:\Program Files\MySQL\MySQL Server 5.1\binmysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)'
--
Why do I get this result? Thanks.
Best Regards
Xiaoming
Hi,
As the console print,do you enter the password for user ODBC correctly?
How to correctly use this console application, that is how to pass password
when calling this console application? Thanks.
ODBCÓû§ÃÜÂë²»¶Ô£¬ËµµÄºÜÃ÷ÏÔ.
:
--
C:\Program Files\MySQL\MySQL Server 5.1\binmysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)'
--
Why do I get this result? Thanks.
Best Regards
Xiaoming
Hi Shawn,
You forgot to use -- before the option version. Try this instead
mysqladmin --version
Let us know your results.
Oh yes, it works. When I typed the right command: mysqladmin --version
I got the following result: mysqladmin Ver 8.42 Distrib 5.1.50, for Win32 on
ia32
Many thanks
都是中国人就说中文吧^_^
明天会更好
On Sat, Sep 25, 2010 at 9:21 AM, Ma Xiaoming maxiaoming10...@hotmail.comwrote:
Hi Shawn,
You forgot to use -- before the option version. Try this instead
mysqladmin --version
Let us know your results.
Oh yes, it works. When I typed the right command:
太搞笑了，哈哈
2010/9/25 Neo neocana...@gmail.com
都是中国人就说中文吧^_^
明天会更好
On Sat, Sep 25, 2010 at 9:21 AM, Ma Xiaoming maxiaoming10...@hotmail.com
wrote:
Hi Shawn,
You forgot to use -- before the option version. Try this instead
mysqladmin --version
Let us know your results.
Hi all,
when i m trying to access phpmyadmin it gives the error
*
#1045 - Access denied for user 'pma'@'localhost' (using password: NO) **
*How could i fix the problem
olease help me, Advanced thanx to you.
-Regards
Ganeswar Mishra
Junior Programmer
TathyaSoft pvt. ltd.
(+91)9438014761
Hi everyone --
I'm pretty new to MySql, but not many years ago I was an ISAM guy so I
understand the issues with indexes and on-the-fly inserts.
I've seen many questions around this error message, Access denied; you need
the RELOAD privilege for this operation. But I'm not grokking
In the last episode (Sep 20), Pete Wilson said:
I'm pretty new to MySql, but not many years ago I was an ISAM guy so I
understand the issues with indexes and on-the-fly inserts.
I've seen many questions around this error message, Access denied; you
need the RELOAD privilege
the password for this
dbuser due to it being hijacked to drop our tables.
My problem is, mysqldump now keeps giving me Access denied for this
user and the backup job doesn't go through.
I can log into MySQL Query Browser and even Administrator fine with
the new password however.
Any clues/pointers
- Original Message -
From: Jim Lyons
To: Jesse
Cc: MySQL List
Sent: Friday, October 10, 2008 8:28 AM
Subject: Re: access denied error
What is the PHP connect string? Are you connecting to the database you have
access to? are you connecting as the same user (myuser)? Do
for the password
and after typing it in, I'm in. I can also see the only database I've given
that user access to, and I tried a simple SELECT and it worked fine.
However, when I access the database through the PHP application, I get the
error, Access denied for user 'trucksma_db'@'localhost' (using
it in, I'm in. I can also see the only database I've given
that user access to, and I tried a simple SELECT and it worked fine.
However, when I access the database through the PHP application, I get the
error, Access denied for user 'trucksma_db'@'localhost' (using password:
YES)
Can anyone tell
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
GUI. This should solve the problem.
CHAVA
On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney
[EMAIL PROTECTED]wrote:
Hello
I am still getting the MySQL Error Number 1045 Access denied error message
when running the adminstrator gui. I attempted to start mysql from the dos
command line via
16, 2008 at 10:22 PM, AndrewMcHorney
[EMAIL PROTECTED]wrote:
Hello
I am still getting the MySQL Error Number 1045 Access denied error
message when running the adminstrator gui. I attempted to start mysql
from the dos command line via mysql and I am getting the following.
ERROR 1045 (28000
.
CHAVA
On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]wrote:
Hello
I am still getting the MySQL Error Number 1045 Access
denied error message
when running the adminstrator
the problem.
CHAVA
On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]wrote:
Hello
I am still getting the MySQL Error Number 1045 Access
denied error message
]wrote:
Hello
I am still getting the MySQL Error Number 1045 Access denied error message
when running the adminstrator gui. I attempted to start mysql from the dos
command line via mysql and I am getting the following. ERROR 1045 (28000):
Access denied for user 'ODBC'@'localhost' (using
.
CHAVA
On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney
[EMAIL PROTECTED]wrote:
Hello
I am still getting the MySQL Error Number 1045 Access denied error message
when running the adminstrator gui. I attempted to start mysql from the dos
command line via mysql and I am getting the following
Hello
I am still getting the MySQL Error Number 1045 Access denied error
message when running the adminstrator gui. I attempted to start mysql
from the dos command line via mysql and I am getting the following.
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using
password
at 20:35 -0400, Jesse wrote:
OK. This is driving me Nutz 8-p
Any time I try to restart mysql, I get the error, Access denied for user
'debian-sys-maint'@'localhost'
My understanding is that the password for the debian-sys-maint user is found
in /etc/mysql/debian.cnf So, I edit
That was it. Once I removed PASSWORD, it went through, and I'm able to restart
MySQL now.
Thanks for your help.
Jesse
- Original Message -
From: Ian Simpson
To: Jesse
Cc: MySQL List
Sent: Tuesday, July 22, 2008 4:48 AM
Subject: Re: Access denied for user 'debian-sys
OK. This is driving me Nutz 8-p
Any time I try to restart mysql, I get the error, Access denied for user
'debian-sys-maint'@'localhost'
My understanding is that the password for the debian-sys-maint user is found
in /etc/mysql/debian.cnf So, I edit that, and note the password.
I
Do you login via sock or network ?
Didja change the passwd for localhost and % ?
--Original Message--
From: Jesse
To: MySQL List
Sent: Jul 21, 2008 17:35
Subject: Access denied for user 'debian-sys-maint'@'localhost'
OK. This is driving me Nutz 8-p
Any time I try to restart mysql, I
Hello MySQL List,
Thanks Ken and HongKong0888 for the advice and suggestions.
I hate when these kinds of problems just fade away with no
resolution or analysis of the resolved issue. So, with that,
here is the explanation for what caused THIS particular
problem (can you say user error?).
In
My guess is that you have the privileges set on your local box that
allow connections with those credentials but the same privileges are
not set up on your clients machines.
Although using apache as a user without a password is quite a security
risk. And then mailing those details to a public
hundreds of times with no trouble
but the last two in a row have required that the permissions be reset.
I am just looking at the error messages in the emails I am getting and
apparently it is not just the Apache user. It is sending access denied
for the site account owner too, I just noticed.
I am using
' WITH GRANT OPTION |
1 row in set (0.00 sec)
When I execute the GRANT on _ANY_ database, I receive the following error:
mysql GRANT ALL PRIVILEGES ON `foo`.* TO 'root'@'localhost'
IDENTIFIED BY PASSWORD 'MYSQL5_PASSWORD_HASH';
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'foo
' WITH GRANT OPTION |
1 row in set (0.00 sec)
When I execute the GRANT on _ANY_ database, I receive the following error:
mysql GRANT ALL PRIVILEGES ON `foo`.* TO 'root'@'localhost'
IDENTIFIED BY PASSWORD 'MYSQL5_PASSWORD_HASH';
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'foo
): Access denied for user 'root'@'localhost' to database
'foo'
I have tried revoking the grant (with --init-file), then reissuing it.
This has not remedied it.
It was recently upgraded from MySQL 4, it is currently running on
mysql Ver 14.12 Distrib 5.0.27.
I have ran
Car Toper wrote:
More info...
I am able to login with the account via phpMyAdmin on the server.
Also, I am trying to use phpMyAdmin to change the permissions, but I
cannot figure out the syntax:
GRANT ON ppsntracker.* TO [EMAIL PROTECTED] WITH GRANT OPTION;
Cartoper
On 8/21/07, Car
I have a MySql server running on a Windows box that I cannot connect
to from another machine. I first checked to make sure the user has
the correct permissions, which the user does, it has the %. I did
read something that gave me the impression the user needs to have a
tranditional windows
More info...
I am able to login with the account via phpMyAdmin on the server.
Also, I am trying to use phpMyAdmin to change the permissions, but I
cannot figure out the syntax:
GRANT ON ppsntracker.* TO [EMAIL PROTECTED] WITH GRANT OPTION;
Cartoper
On 8/21/07, Car Toper [EMAIL PROTECTED]
happened:
$ mysql -u untz -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 5.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql create database people_development;
ERROR 1044 (42000): Access
' to clear the buffer.
mysql create database people_development;
ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to
database 'people_development'
mysql
Try running SHOW GRANTS while logged in, and see what privileges you
have. You probably need to grant your user some additional
with ; or \g.
Your MySQL connection id is 4 to server version: 5.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql create database people_development;
ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to
database 'people_development'
mysql
Try running SHOW
. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 5.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql create database people_development;
ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to
database 'people_development'
mysql
[mailto:[EMAIL PROTECTED]
Sent: Monday, June 11, 2007 4:02 PM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Subject: Re: Access Denied When Trying to Create Database
Ananda,
Thank you for responding!
I just tried this and got the following:
mysql grant super *.* to 'untz'@'localhost' identified
Gerald,
I tried this and still got an error!
mysql grant all privileges on *.* to 'untz'@'localhost' identified
by 'maddog';
ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using
password: YES)
mysql
Can anyone please help me? I am unable to use MySQL at all
'
identified by 'password';
Not grant super *.* to 'untz'@'localhost' identified by 'password';
Regards,
Mikhail Berman
-Original Message-
From: untz [mailto:[EMAIL PROTECTED]
Sent: Monday, June 11, 2007 4:02 PM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Subject: Re: Access Denied When Trying
1 - 100 of 580 matches
Mail list logo
