Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

ok I have tried these : ifconfig -a lo0: flags=8049 mtu 16384 inet6 ::1 prefixlen 128 inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1 inet 127.0.0.1 netmask 0xff00 gif0: flags=8010 mtu 1280 stf0: flags=0<> mtu 1280 fw0: flags=8863 mtu 4078 lladdr 70:cd:60:ff:fe:eb:72:ea media:

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

Hi > > > | | ericomtxmacbookpro.local | > > *E85DC00A0137C6171923BE35EDD809573FB3AB4F | > > > > mysql> DELETE FROM mysql.user WHERE user=''; mysql> FLUSH PRIVILEGES; maybe helps? Cheers -- Claudio

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

+---+ > > 5 rows in set (0.00 sec) > > > > all passwords are filled in the db ... > > > > also ... I can connect through command line > > > > what I can't do is : > > 1. connect or even ping ins

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

Am 13.01.2014 21:47, schrieb shawn l.green: > Hello Reindl, > We are not saying he is using HTTP commands to log into his database we excludes obviously the OP or his overall understanding :-) Am 13.01.2014 18:54, schrieb Érico: > using both urls I get the same error : > > http://localhost/mysql

RE: Access denied for user 'root'@'localhost' (using password:

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

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

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* a

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

*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/re

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

gt;> 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

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

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 conne

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

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

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

he > manual > > that corresponds to your MySQL server version for the right syntax to use > > near 'to *.* 'root'@'127.0.0.1' identified by kernel26' at line 1 > It's my error :) It should be: > > mysql> grant all privileges on *.* to &#x

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

ur MySQL server version for the right syntax to use > near 'to *.* 'root'@'127.0.0.1' 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'

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

by kernel26' at line 1 ... in eclipse using jconnector ... I get the same error : when pinging : java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQL

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

or. 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 &

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

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 Oc

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

gt; Am 13.01.2014 18:28, schrieb Érico: > >> 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

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

ro: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 er

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

r. 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' (using password: YES) >>

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

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

Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

. 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

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

ew-password' You 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 &#

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

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,

mysql_upgrade not running mysql_check: Access denied for user 'root'@'localhost'

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 '/u

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost'

s Armstrong <[EMAIL PROTECTED]> wrote: 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'@

ERROR 1045 (28000): Access denied for user 'root'@'localhost'

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) ---

ERROR 1045 (28000): Access denied for user 'root'@'localhost'

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) ---

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Hello. > mysqladmin:connect to server at 'localhost' failed > error: 'Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2)' ... > shell>safe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid > --skip-grand-tables & > [1] 28712 > shell> Sta

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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 (yourpass

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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 di

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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 o

Re: Access denied for user: 'root@localhost' (Using password: NO)

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? > http://dev.mysql.com/doc/mysql/en/User_Account_Mana

RE: Access denied for user: 'root@localhost' (Using password: NO)

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 (M

Re: Access denied for user: 'root@localhost' (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-installed MySQL by rpm and when ever I try to issue a command from the shell prompt, such as mysqladmin or mysqlshow, I would ge

Access denied for user: 'root@localhost' (Using password: NO)

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]' (Using password: NO)'. Could someone please tell me what

Access denied for user: 'root@localhost' (Using password: NO)

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 use

Re: Access denied for user: 'root@localhost'

"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

Access denied for user: 'root@localhost'

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 t

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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" in the manual. M

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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 Pahlevanzadeh/

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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 basi

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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 r

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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. > >

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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:http://lists.mysql

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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 administ

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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 y

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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 so

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

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]

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

> 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

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

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

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

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.

ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

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 r

re: Re: access denied for user: root@localhost

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 d

Re: access denied for user: root@localhost

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:

Re: access denied for user: root@localhost

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 +

Re: access denied for user: root@localhost

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: $

Re: access denied for user: root@localhost

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 

Re: access denied for user: root@localhost

; > >$ 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? > > > > Thanks, > &g

Re: access denied for user: root@localhost

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 &

access denied for user: root@localhost

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@localhost' (Using password: NO)' Could

Re: error: 'Access denied for user: 'root@localhost' (Using password: NO)'

ot &) > If i try to add: > mysql -u root -p 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 > er

Re: error: 'Access denied for user: 'root@localhost' (Using password: NO)'

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)' > [r

error: 'Access denied for user: 'root@localhost' (Using password: NO)'

ry 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 foll

RE: ERROR 1045: Access denied for user: 'root@localhost'

PROTECTED] 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... Could you explain the difference between Linux 'root' user and 'root' user in MySQL? Subje

Re: ERROR 1045: Access denied for user: 'root@localhost'

[EMAIL PROTECTED] - 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 ca

Re: Re: ERROR 1045: Access denied for user: 'root@localhost'

'root' user in Linux is a "superuser" of OS, not of MySQL. Look at the MySQL 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.htm

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... 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

Re: ERROR 1045: Access denied for user: 'root@localhost'

>> [root@omsrh etc]# mysql -u root -p >> Enter 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,

ERROR 1045: Access denied for user: 'root@localhost'

; ERROR 1045: Access denied for user: '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 t

Access denied for user: 'root@localhost'

... C:\mysql\bin>mysqlshow -u root mysql mysqlshow: Access denied for user: 'root@localhost' (Using password: NO) C:\mysql\bin>mysql mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' C:\mysql\bin\mys