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
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 :
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
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
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
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-installed MySQL by rpm and when ever I try to issue
a command from the shell prompt, such as mysqladmin or mysqlshow, I would
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?
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 8:57 AM
To: Nguyen, Long P
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?
Hello,
I would be happy to solve the following problem :
I get every week the following message on my Linux root mail account :
/etc/cron.daily/logrotate:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for
Hi All,
I have just installed mysql-4.0.18 on my cobalt RaQ4 and for the first time
seemed to actually got somewhere! however, my existing PHP scripts failed to
connect to localhost as the password has not been set after the install. I
ran the following command (obviously seriously misunderstood
Phil Ewington - 43 Plc [EMAIL PROTECTED] wrote:
Hi All,
I have just installed mysql-4.0.18 on my cobalt RaQ4 and for the first time
seemed to actually got somewhere! however, my existing PHP scripts failed to
connect to localhost as the password has not been set after the install. I
ran the
Hi,When i run mysql,mysqlshow,mysqladmin etc from
mysql command,I receive following error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO)
I have RH9.
Please guide me.
Yours,Mohsen.
=
-DIGITAL SIGNATURE---
///Mohsen
According to the error message, [EMAIL PROTECTED] has a password, but you
aren't supplying it. Add -p to your commands to be prompted for the password.
If you don't know the password, see How to Reset The Root Password
http://www.mysql.com/doc/en/Resetting_permissions.html in the manual.
I didn't found hostname.pid file.
SOS SOS
--- J.R. Bullington [EMAIL PROTECTED] wrote:
The next step is to shutdown mysqld, delete the
mysql and temp tables from
your /data/ folder, and then re-run the
scripts/mysql_install_db. That will
reinstall the mysql/hosts.frm, which will basically
hi,i was attemping,But my problem didn't solved.
SOS SOS
--- J.R. Bullington [EMAIL PROTECTED] wrote:
Did you change the mysql root password by running:
mysqladmin -u root password 'newpassword'?
If so, try:
mysql -u root -p
It will then prompt you to enter a password.
J.R.
The next step is to shutdown mysqld, delete the mysql and temp tables from
your /data/ folder, and then re-run the scripts/mysql_install_db. That will
reinstall the mysql/hosts.frm, which will basically reset your root user and
password. However, it will also kill any users you have created.
To
Hi.
When i run mysql,mysqlshow,mysqladmin or .,I
receive following error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO)
Please guide me..
Yours,Mohsen.
=
-DIGITAL SIGNATURE---
///Mohsen Pahlevanzadeh
Network
Did you change the mysql root password by running:
mysqladmin -u root password 'newpassword'?
If so, try:
mysql -u root -p
It will then prompt you to enter a password.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello,
I am having a hard time getting Mysql to let [EMAIL PROTECTED] connect.
I am constantly getting this:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
when I issue mysql -u root
I can log in if I use mysql -h 192.168.1.10 -u root mysql
I guess I have some
Hi!
You seems to have just installed mysql. The root user should be able to
acces a mysql server from anywhere by default. I don't know why you can
connect from localhost, probably you delete the [EMAIL PROTECTED]? Anyway
it is a good thing to delete the root user after the initial setup, once
now allowing clients to login but I'm not sure what would cuse it not to
allow root to change the password, I dubble and triple checked my entry
but still nothing happens. Once I login to root I do the following
mysql use mysql
mysql UPDATE user SET Password= ('x')
- WHERE
I figured it out. Actualy silly me forgot to add the password() function
how embarising. :)
--
Jerry M. Howell II
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hey there all,
Here is the problem I am haveing and was wondering if anyone can help
me here. I was getting the following error when loging into mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
After searching for an answer I found the answer was to
Jerry,
Don't forget that MySQL authenticates an entity, which is based on the user
name and host. For example, on my MySQL boxes root can only login from the
localhost. If I attempt to login with root from another host, I am denied
access.
Regards,
Adam
-Original Message-
From: Jerry M.
On Fri, Sep 05, 2003 at 01:34:01PM -0400, Fortuno, Adam wrote:
Jerry,
Don't forget that MySQL authenticates an entity, which is based on the user
name and host. For example, on my MySQL boxes root can only login from the
localhost. If I attempt to login with root from another host, I am
use: mysqladmin -u root -p
It will prompt you for the password
On Tue, 2002-11-05 at 10:03, Jack Chen wrote:
Dear all,
When I ran the follwing command:
$ mysqladmin -u root password PASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root
' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
Could you inform me why?
Thanks,
Jack
Jack Chen, Stein Lab, Cold Spring Harbor Labs
1 Bungtown Road, Cold Spring Harbor, NY, 11724
Tel: 1 516 3676904
denied for user: 'root@localhost' (Using password: NO)'
Could you inform me why?
Thanks,
Jack
Jack Chen, Stein Lab, Cold Spring Harbor Labs
1 Bungtown Road, Cold Spring Harbor, NY, 11724
Tel: 1 516 3676904; e-mail: [EMAIL
Jack Chen wrote:
$ mysqladmin -u root password PASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
Could you inform me why?
That's why:
$ mysqladmin -uroot -pyourpassword PASSWORD newpassword
--
./ premax
Thanks, but I still got complains that can't access server:
'Access denied for user: 'root@localhost' (Using password: YES)
Is it possible that for some reason the password is wrong?
You input is greatly appreaciated,
Puzzled newbie,
Jack
Jack
Just a question, did you ever change your password for Mysql? If not
don't use the -p option
mysqladmin -u root create testdb
On Tue, 2002-11-05 at 11:08, Jack Chen wrote:
Thanks, but I still got complains that can't access server:
'Access denied for user: 'root@localhost' (Using password
Jack,
Tuesday, November 05, 2002, 6:08:58 PM, you wrote:
JC Thanks, but I still got complains that can't access server:
JC 'Access denied for user: 'root@localhost' (Using password: YES)
JC Is it possible that for some reason the password is wrong?
Yup. If you don't remember 'root' password
to add:
mysql -u root -p mysql
It still just sits,...
[root@RR davidwri]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
I did Set the password, based on the following syntax example (with my value
On Fri, 21 Jun 2002 03:59:33 -0400
david [EMAIL PROTECTED] wrote:
[root@RR davidwri]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
[root@RR davidwri]# mysql -u root -p mysql
Enter password
mysql
It still just sits,...
That's right. You didn't get your prompt back as you wrote earlier.
[root@RR davidwri]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
You tell the mysql client
I am having the same problem and cannot find any document which can get
me beyond Access denied...
Could you explain the difference between Linux 'root' user and 'root'
user in MySQL?
Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
From: Victoria Reznichenko
Date: Tue, 23 Apr
documentation, there are a LOT a of info about
privilege system in MySQL:
http://www.mysql.com/doc/P/r/Privilege_system.html
http://www.mysql.com/doc/U/s/User_Account_Management.html
TM Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
TM From: Victoria Reznichenko
]
- Original Message -
From: Tom McDonough [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 25, 2002 5:40 PM
Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
I am having the same problem and cannot find any document which can get
me beyond Access denied
denied for user: 'root@localhost'
I am having the same problem and cannot find any document which can get
me beyond Access denied...
Could you explain the difference between Linux 'root' user and 'root'
user in MySQL?
Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
From
password:**
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
If you didn't set password, you don't have to use '-p' option for
connection.
If you want to set password, please, chaeck the following link:
http://www.mysql.com/doc/P/a/Passwords.html
[root@omsrh
: 'root@localhost' (Using password: YES)
[root@omsrh etc]# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
I was able access Mysql not being root, but couldn't get access to 'mysql'
database to change user options and all.
When accessing mysql as a user, I
...
C:\mysql\binmysqlshow -u root mysql
mysqlshow: Access denied for user: 'root@localhost' (Using password: NO)
C:\mysql\binmysql mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
C:\mysql\bin\mysql test (this works ok)
tia
chris
77 matches
Mail list logo