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
| 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 :
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
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
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
Hello mysql,
I just started having this problem and wonder if someone might give me
a clue why this is happening. The scenario is that I build a CMS on my
local XP system to make sure it is working correctly and customize it
per the client's specifications. Almost always the client has some
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]
Hi,
I installed mysql 4.1.22 for Debian testing.
I launched the manual installation.
However, when I do :
mysql -u root
I get :
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
I tried to reinstall it, but it fails.
Thanks for help,
Thibaud.
--
MySQL
may have to give the complete path to mysqladmin.
CheersCassj
-Original Message-
From: Thibaud Hulin [EMAIL PROTECTED]
Sent: May 9, 2007 4:13 PM
To: mysql@lists.mysql.com
Subject: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
Hi,
I installed mysql
Hi,
When I try mysql_upgrade I get a connection problem,
$ mysql_upgrade -p
Enter password:
/usr/bin/mysqlcheck: Got error: 1045: Access denied for user
'root'@'localhost' (using password: YES) when trying to connect
Error executing '/usr/bin/mysqlcheck --check
Hi.
Using mySQL 4.1.22 on Linux, I got this error message suddenly this
morning (it worked ok yesterday):
-
[EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
--
I created
Hi.
Using mySQL 4.1.22 on Linux, I got this error message suddenly this
morning (it worked ok yesterday):
-
[EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
--
I created
.
Using mySQL 4.1.22 on Linux, I got this error message suddenly this
morning (it worked ok yesterday):
-
[EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
--
I created a '/root
afternoon, i am triying to connect with my company's
mysql server using a client program from shell and I keep
receiving the following answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user
'user1'@'200.93.42.209
Hi good afternoon, i am triying to connect with my company's mysql
server using a client program from shell and I keep receiving the
following answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209
Levy wrote:
Hi good afternoon, i am triying to connect with my company's mysql
server using a client program from shell and I keep receiving the
following answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user
'user1
the
following answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209'
(using password: YES)
[EMAIL PROTECTED] ~]#
I already checked the user was configured for any host (%), the
port 3306 is open
On 6/7/06, Aron Levy [EMAIL PROTECTED] wrote:
Hi James i follow your recomendation and verify that the hash produced
matches the password field in user exactly.
-- Aron L.
Well, that's weird, should be working. A shot in the dark: try
starting your server with --old-passwords as an option
] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user
'user1'@'200.93.42.209' (using password: YES)
[EMAIL PROTECTED] ~]#
I already checked the user was configured for any host (%),
the port 3306 is open (checked with nmap), but i dont know
message would be the one that I'm getting?
Thanx in advance,
Jorge
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
Date: Mon, 18 Apr 2005 18:38:54 +0300
Hello.
It is strange that refusing message says
Hello.
Could be that the connect command fails, then I start trying and trying,
and then the server blocks because it receives too many connections? Then
the error message would be the one that I'm getting?
I also thought about this and therefore I gave you that advice. What
is
I have a web application running with Apache with PHP 4.1.2 (revision
7.2.6) and MySQL 3.23.58.
The access from the PHP code to the MySQL server using the IP of the
machine with MySQL, an username and a password, and it works fine.
But sometimes we get the MySQL error:
Access denied
(revision
7.2.6) and MySQL 3.23.58.
The access from the PHP code to the MySQL server using the IP of the
machine with MySQL, an username and a password, and it works fine.
But sometimes we get the MySQL error:
Access denied for user: '[EMAIL PROTECTED]' (Using password
Howdy all,
I keep getting this error when I try to issue:
mysql mysql -u root -p
the same thing happens when I substitute any other database name, not just
mysql. I have another,nearly identical machine from which I copied the
contents of /var/lib/mysql/mysql/ . The permissions all appear to
Hello.
mysqladmin:connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)'
...
shellsafe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid
--skip-grand-tables
[1] 28712
shell Starting
Hi,
I have had to change mysql root passwd
My procedure is just below
shell mysql -u root -p
mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
mysql flush privileges;
and I checked this password another consol I saw MySQL wasn't
accepted new passwd else, it didnt old
Hi,
I have had to change mysql root passwd
My procedure is just below
shell mysql -u root -p
mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
mysql flush privileges;
and I checked this password another consol I saw MySQL wasn't
accepted new passwd else, it
Deniss Hennesy wrote:
Hi,
I have had to change mysql root passwd
My procedure is just below
shell mysql -u root -p
mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
mysql flush privileges;
YOu may be need to execute command mysqladmin -u root password
Hello.
I successufully connected to MySQL server using your parameters
in odbc.ini and odbcinst.ini files from php.
[unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user:
'[EMAIL PROTECTED]' (Using password: NO)
You have specified the user and the password in the ODBC
][ODBC 3.51 Driver]Access denied for user:
'[EMAIL PROTECTED]' (Using password: NO)
The user apacheusr is the username that the Apache webserver is running
under. I've tried adding this user to the MySQL user table but the error
still shows.
However, if I add the Username and Password along
Hi All,
I am consistently getting;
Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
I am connecting through php with the same script I use all the time, I have
checked it and dbl checked it for problems.
I can connect to mysql in a prompt and I have added new users with all
hi
you are not passing a password to mysql - check your code to see if this is
correct.
Peter
-Original Message-
From: Christian Biggins [mailto:[EMAIL PROTECTED]
Sent: 26 January 2005 12:27
To: mysql@lists.mysql.com
Subject: Access denied for user - I cant work this out
Hi All
: Peter Lovatt [mailto:[EMAIL PROTECTED]
Sent: Thursday, 27 January 2005 12:27 AM
To: Christian Biggins; mysql@lists.mysql.com
Subject: RE: Access denied for user - I cant work this out
hi
you are not passing a password to mysql - check your code to see if this is
correct.
Peter
-Original
Subject: RE: Access denied for user - I cant work this out
Hi Peter,
There is a password being suppled - see code (btw, its local testing only,
hence the root user)
//Database Settings
$db_host = 'localhost'; //database hostname $db_name =
'powerpla_powerplay'; //database name $db_user
');
}
}
HTH
Peter
-Original Message-
From: Christian Biggins [mailto:[EMAIL PROTECTED]
Sent: 26 January 2005 13:30
To: 'Peter Lovatt'; mysql@lists.mysql.com
Subject: RE: Access denied for user - I cant work this out
Hi Peter,
There is a password being suppled - see code (btw
by 'password';
ERROR 1044 (42000): Access denied for user 'root'
What could be the reason???
I though the mysql root user was analogous to the unix counterpart
Thanks a lot in advance for your help.
Regards,
Ed
--
For technical support contracts, goto https
Hi,
As the root user I created a DB a populated with tables... but when I want
to create a user to handle that DB i get this error message:
mysql grant all on db.* to [EMAIL PROTECTED] identified by 'password';
ERROR 1044 (42000): Access denied for user 'root'
What could be the reason???
I
!!! [mailto:[EMAIL PROTECTED] On
Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, December 15, 2004 11:34 AM
To: [EMAIL PROTECTED]
Subject: ERROR 1044 (42000): Access denied for user 'root'
Hi,
As the root user I created a DB a populated with tables... but when I
want
to create a user to handle
User mysqladmin has not the rights to access mysql? How can that be?
Laurent
--
Linux is like an Indian tent: no Windows, no Gates, and an Apache inside!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqladmin is an executable. Did you set up an user named mysqladmin that
can connect from the localhost?
-Original Message-
From: Laurent
To: [EMAIL PROTECTED]
Sent: 7/19/04 6:55 AM
Subject: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
User mysqladmin
On Monday 19 July 2004 14:59, Victor Pendleton wrote:
mysqladmin is an executable. Did you set up an user named mysqladmin that
can connect from the localhost?
Exactly, it should be able to connect, but it doesn't. Should I change the
name from mysqladmin to mysql or something similar? I'll
On Mon, 19 Jul 2004, Laurent wrote:
On Monday 19 July 2004 14:59, Victor Pendleton wrote:
mysqladmin is an executable. Did you set up an user named mysqladmin that
can connect from the localhost?
Exactly, it should be able to connect, but it doesn't. Should I change the
name from
Have you tried another user.
-Original Message-
From: Laurent
To: [EMAIL PROTECTED]
Sent: 7/19/04 8:07 AM
Subject: Re: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (U
sing password: YES)
On Monday 19 July 2004 14:59, Victor Pendleton wrote:
mysqladmin is an executable. Did
Laurent [EMAIL PROTECTED] wrote:
User mysqladmin has not the rights to access mysql? How can that be?
Have you created the mysqladmin user? By default there is no such user and
it's not supposed to be there. There is no special meaning for it - mysqladmin
usually logs in as root user.
--
Hi -
I am new to MySQL - I just recently re-installed MySQL by rpm and when ever I try to
issue a command from the shell prompt, such as mysqladmin or mysqlshow, I would get
the error of 'Access denied for user: '[EMAIL PROTECTED]' mailto:'[EMAIL PROTECTED]'
(Using password: NO)'.
Could
get the error of
'Access denied for user: '[EMAIL PROTECTED]' mailto:'[EMAIL PROTECTED]' (Using
password: NO)'.
Could someone please tell me what I need to set or did not set.
Thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
(Mission Systems)
Cc: [EMAIL PROTECTED]
Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
Re-installing does not get rid of your old passwords.
You need to use the -p option.
Nguyen, Long P (Mission Systems) wrote:
Hi -
I am new to MySQL - I just recently re
On Thursday 01 July 2004 09:08 am, Nguyen, Long P (Mission Systems) wrote:
shouldn't I be able to issue commands at the shell it goes and does it
thing and give back output? or does this mean I have a passwd already set
and it's secured?
:
# mysql --user=foo --password=password -h host foo
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
I've only managed to find a single thread about this issue which was a
bug in the installation of mysql on RedHat 7. Many months have gone by
since then so I
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
I've only managed to find a single thread about this issue which was a
bug in the installation of mysql on RedHat 7. Many months have gone by
since then so I wonder if this is still the same issue.
--
Marc Tardif
CREATE DATABASE menagerie;
ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
I have read the documentation again and again, it show I can create a host file, but
ite does not say what kind file it is and where I should put it. How can I fix it?
Thank you for your help
)
mysql CREATE DATABASE menagerie;
ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
You did not start mysql as root.
mysql -u root
I have read the documentation again and again, it show I can create a host file, but
ite does not say what kind file it is and where I should put
the command-line 'mysql -u abcd'
* I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa'
o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
* As root I have executed 'USE mysql; SELECT USER,PASSWORD FROM USER' and have
verified the password
can login using the command-line 'mysql -u abcd'
* I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa'
o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
* As root I have executed 'USE mysql; SELECT USER,PASSWORD FROM USER' and have
verified
a password
xxyyzzaa
* I can login using the command-line 'mysql -u abcd'
Seems you connected as anonymous user. Check it with SELECT CURRENT_USER() function.
* I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa'
o ERROR 1045: Access denied for user: '[EMAIL PROTECTED
I figured this out. It's the ANY setup in Privileges. Being set to allow ANY user to
login without password, MySQL interestingly interprets
that as even known users with passwords MUST log in without passwords. My two
solutions were either to delete the ANY privileges or
to create a second
Jack Woehr wrote:
I figured this out. It's the ANY setup in Privileges. Being set to
allow ANY user to login without password, MySQL interestingly interprets
that as even known users with passwords MUST log in without passwords.
Well, that seems to be the effect, but that's not what it is doing.
for user: '[EMAIL PROTECTED]' (Using password: NO)'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
I looked many times on Internet for this kind of problem, and I
the docs)
mysqladmin -u root password new-password
I thought the above syntax would ask me for the password but it didn't now
all commands return
'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
How do I actually set a password, and more importantly, how do I reset the
password
the following command (obviously seriously misunderstood the docs)
mysqladmin -u root password new-password
I thought the above syntax would ask me for the password but it didn't now
all commands return
'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
How do I actually
.* TO [EMAIL PROTECTED] IDENTIFIED BY
'mysqlpassword'
GRANT ALL ON database.* TO mysqlusername\@'%' IDENTIFIED BY 'mysqlpassword'
But through script I cannot access the database it shows an error message
DBI connect ('lab:iidcm063.iidc.lucent.com','lrmt',...) failed: Access
denied for user: '[EMAIL
1 - 100 of 195 matches
Mail list logo