Re: access denied fpr user 'root'@'localhost' (using password: NO)

/ server and db using both localhost and 127.0.01 ... it gets the same error : access denied for user 'root'@'localhost' the app has a php config page where it fills these info I am able to connect to it manually too using : ./mysql -h localhost -u root -p mysql-admi

Re: access denied fpr user 'root'@'localhost' (using password: NO)

... it gets the same error : access denied for user 'root'@'localhost' the app has a php config page where it fills these info I am able to connect to it manually too using : ./mysql -h localhost -u root -p mysql-admin but the app keeps geting the access denied error w

Re: access denied fpr user 'root'@'localhost' (using password: NO)

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 I get access denied for

Re: access denied fpr user 'root'@'localhost' (using password: NO)

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

Re: access denied fpr user 'root'@'localhost' (using password: NO)

here user=''; > > 2lines got effected > > > > after this I can´t connect through command line anymore : > > > > ./mysqladmin -u root password > > > > I get access denied for user 'root'@'localhost" (using password:'NO&#

Re: access denied fpr user 'root'@'localhost' (using password: NO)

have ran the following to test a fix for an app issue : >> >> delete from mysql.user where user=''; >> 2lines got effected >> >> after this I can´t connect through command line anymore : >> >> ./mysqladmin -u root password >> >> I get access den

Re: access denied fpr user 'root'@'localhost' (using password: NO)

#x27;; > 2lines got effected > > after this I can´t connect through command line anymore : > > ./mysqladmin -u root password > > I get access denied for user 'root'@'localhost" (using password:'NO') > > how can I restore the db so I can connect through command line again ? > > thks >

Re: access denied fpr user 'root'@'localhost' (using password: NO)

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

access denied fpr user 'root'@'localhost' (using password: NO)

I have ran the following to test a fix for an app issue : delete from mysql.user where user=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password I get access denied for user 'root'@'localhost" (using pas

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

broadcasthost >>> ::1 localhost >>> #fe80::1%lo0localhost >>> 127.0.0.1 ericomtxmacbookpro.local >>> #127.0.0.1 mysqld >>> >>> >> The thing to remember is that 'localhost' or '127.0.0.1' is where

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

The thing to remember is that 'localhost' or '127.0.0.1' is where the > server believes the connection is coming from. The password you must be > using in your client connection attempt must match the one used on the > server for the mysql user 'root'@'

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

emember is that 'localhost' or '127.0.0.1' is where the server believes the connection is coming from. The password you must be using in your client connection attempt must match the one used on the server for the mysql user 'root'@'localhost' or you will n

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: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

On Mon, 06 Jun 2011 18:54 +0200, "Johan De Meersman" wrote: > > Excluding 'performance_schema' appears to eliminate the error. And it > > seems does NOT cause a reliability-of-the-backup problem. > > Hah, no, backing that up is utterly pointless. that's a useful/final confirmation. thx. > No,

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

- Original Message - > From: ag...@airpost.net > > Excluding 'performance_schema' appears to eliminate the error. And it > seems does NOT cause a reliability-of-the-backup problem. Hah, no, backing that up is utterly pointless. Never noticed it doing that. It's basically a virtual schem

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

On Mon, 06 Jun 2011 12:44 +0200, "Johan De Meersman" wrote: > > I haven't bothered to look for the "bug", but it seems to me to be quite > reasonable default behaviour to lock the whole lot when you're dumping > transactional tables - it ensures you dump all tables from the same > consistent vi

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

I haven't bothered to look for the "bug", but it seems to me to be quite reasonable default behaviour to lock the whole lot when you're dumping transactional tables - it ensures you dump all tables from the same consistent view. I would rather take this up with the ZRM people - it should "just

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

Am 05.06.2011 23:55, schrieb ag...@airpost.net: > i still have no idea why this is necessary. take it or not it is a professional solution which works for databses with 20 GB every day here with rsync without interrupt/lock mysqld a second and it is much faster > there seems to be a but, prob

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

i still have no idea why this is necessary. there seems to be a but, problem, misconfiguration, etc. wouldn't it make some sense to try to FIX it, rather than setting up a completely different server? perhaps someone with an idea of the problem and its solution will be able to chime in. -- My

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

Am 05.06.2011 23:49, schrieb ag...@airpost.net: > > On Sun, 05 Jun 2011 23:29 +0200, "Reindl Harald" > wrote: >> i would use a replication slave and stop him for consistent backups >> because dumb locks are not really a good solution independent >> if this works "normally" > > unfortunately, i

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

On Sun, 05 Jun 2011 23:29 +0200, "Reindl Harald" wrote: > i would use a replication slave and stop him for consistent backups > because dumb locks are not really a good solution independent > if this works "normally" unfortunately, i have no idea what that means. something's apparently broken w

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

On Sun, 05 Jun 2011 23:30 +0200, "Reindl Harald" wrote: > BTW > WHY is everybody ansering to the list AND the author of the last post? > this reults in get every message twice :-( Reply -> sends to ONLY the From == h.rei...@thelounge.net Reply to all sends to BOTH the From == h.rei...@thelounge.n

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

ng added as i mentioned above, to the [mysqldump] section of > /etc/my.cnf, does NOT make a difference for me. > > > On Sun, 05 Jun 2011 23:19 +0200, "Reindl Harald" > wrote: >> the grant statements does nobody interest >> mysql> select * from mysql.user whe

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

ks to your mysqldump command" > > which, having added as i mentioned above, to the [mysqldump] section of > /etc/my.cnf, does NOT make a difference for me. > > > On Sun, 05 Jun 2011 23:19 +0200, "Reindl Harald" > wrote: >> the grant statements does nobody i

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

-add-locks to your mysqldump command" which, having added as i mentioned above, to the [mysqldump] section of /etc/my.cnf, does NOT make a difference for me. On Sun, 05 Jun 2011 23:19 +0200, "Reindl Harald" wrote: > the grant statements does nobody interest > mysql> select

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

the grant statements does nobody interest maybe use phpmyadmin for a clearer display mysql> select * from mysql.user where user='root&

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

hi, On Sun, 05 Jun 2011 22:24 +0200, "Reindl Harald" wrote: > have you checked you permissions-table if all privileges are active for root i've got, mysql> show grants for 'root'@'localhost'; +--

Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

Command used for logical backup is > "/usr/bin"/mysqldump --opt --extended-insert --create-options > --default-character-set=utf8 --routines --host="localhost" > --port="3306" --socket="/var/cache/mysql/mysql.sock" --databases >

upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES". a bug or my config?

e_schema > "/var/mysql-bkup/manual/20110605131003/backup.sql" mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES --> manual:backup:

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'

Fixed: []# kill `cat /usr/local/mysql/var/server.pid` []# /usr/local/mysql/bin/mysqld_safe --skip-grant-tables& []# /usr/local/mysql/bin/mysql mysql> update user set password = password('xxx') where user = 'root' and host='localhost'; On 2/20/07, thoma

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.

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 comman

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&#x

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 a

Access deined for user 'root@sales'

I'm running v 4.0.22 on Win XP 2003 Server with a client running XP Pro. I have mysql running on 192.168.0.8 and I want to administer it from 192.168.0.202 (aka SALES). While on 192.168.0.8 running mysql, I issued the following commands: mysql> GRANT ALL ON *.* TO 'root'@'192.168.0.22';

Re: ERROR 1044 (42000): Access denied for user 'root'

* to [EMAIL PROTECTED] identified 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. > >

RE: ERROR 1044 (42000): Access denied for user 'root'

rnel-Hacker!!! [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 ta

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

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)

: '[EMAIL PROTECTED]' (Using password: NO)" If I just type "mysql" at command line (as root), it works without error, and without asking me any password. So I suppose that .my.cnf is correctly read : if I remove the password from it, this last command no longer works without

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

7;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 for root, and what did I do? Any help will be greatly appreciated. > Initially user root doesn't have a passwo

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)

leges on *.* to yournewusername_here@"%" identified by 'passowrdhere' with grant option; flush privileges; This will create a new user with a set of rights comparable with the root's own permissions. Now, with this "superuser" created you can delete the root user u

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: unable to access mysql as anyone besideslinux user= root

smrtalec wrote: whenever I try to connect to mysql logged on as anyone besides root I get teh error below. This isnt' making sence to me. The ps-ef output and the permissions info is also included. mysql 2524 2500 0 15:41 pts/100:00:00 /usr/sbin/mysqld-max --basedir=/usr --datadir=

unable to access mysql as anyone besideslinux user= root

whenever I try to connect to mysql logged on as anyone besides root I get teh error below. This isnt' making sence to me. The ps-ef output and the permissions info is also included. mysql 2524 2500 0 15:41 pts/100:00:00 /usr/sbin/mysqld-max --basedir=/usr --datadir=/var/lib/mysql -

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)

TE user SET Password= ('x') > -> WHERE user='root'; > > Here is the response I get > > Query OK, 0 rows affected (0.01 sec) > Rows matched: 4 Changed: 0 Warnings: 0 > > Not sure why nothing is changed? Anyideas. Might root not have the > privlage

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

ange 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 user='root'; Here is the response I get Query OK, 0 rows affected (

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: Access Denied for User: root@127.0.0.1(Using password: NO)

For Mysql, 127.0.0.1 is not the same as localhost. Localhost refers to the socket file on the operating system, and is faster than 127.0.0.1. Use 'root'@'127.0.0.1' in your grant statements. Ola Ogunneye wrote: Please somebody help me. I have installed MySql 4.0.13 and it works up until I try

RE: Access Denied for User: root@127.0.0.1(Using password: NO)

You can try one or the other mysql -h localhost -u root -ppasswd db or mysql -h `uname -n` -u root -ppasswd db in solaris On Mon, 30 Jun 2003, Twibell, Cory L wrote: > Did you flush the privileges after you gave root a password? > The error you get is a result of not using a password to login.

RE: Access Denied for User: root@127.0.0.1(Using password: NO)

Did you flush the privileges after you gave root a password? The error you get is a result of not using a password to login. -Original Message- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2003 6:05 PM To: [EMAIL PROTECTED] Subject: Access Denied for User: [EMAIL PRO

Access Denied for User: root@127.0.0.1(Using password: NO)

Please somebody help me. I have installed MySql 4.0.13 and it works up until I try to apply security settings to the root user at localhost. I see the mysql database and I check the privileges and there is no password for the roo user. But when I assign a password to make it secure, I can run p

Re: user/root

On 1/1/03 5:46 PM, "Richard Nagle" <[EMAIL PROTECTED]> wrote: > Well it would appear that I finally have a connection Congrats. > q. since I am root, do I still need to GRANT a database to myself? > or just a to a new user. aka: bob@localhost If you are the only person using the computer that t

Re: user/root

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rick -- ...and then Richard Nagle said... % ... % [MacG4a:/usr] rnagle% mysql -u root -p % Enter password: % Welcome to the MySQL monitor. Commands end with ; or \g. ... % % Well it would appear that I finally have a connection Yay! :-) % % q.

Re: user/root

On Wednesday, January 1, 2003, at 08:06 PM, R. Hannes Niedner wrote: You have a recent installation of mysql then you can just run SET PASSWORD FOR root@localhost=PASSWORD('tko'); and skip the flush privileges. All explained here: Be

Re: user/root

nt to confirm this is correct before I push enter. > > mysql> update user set password=password('tko') > where user='root'; > > Then next this, > > mysql> flush privileges; > > So, this should add a password for root, yes? > and flush all

user/root

Well after 3 times installing mysql, finally got it working (tks to those whom help) now I need to take care of user and root. first root. mysql> mysql -u root mysql just want to confirm this is correct before I push enter. mysql> update user set password=password('tko')

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

  1   2   >