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: mysql Access denied error

lush privileges; > Query OK, 0 rows affected (0.00 sec) > > mysql> quit; > Bye > > Then I use hadoopuser with password 123456 > [hadoop@master ~]$ mysql -u hadoopuser -p > Enter password: > ERROR 1045 (28000): Access denied for user 'hadoopuser'@'localhost

Re: mysql Access denied error

On 2014-05-04 9:17 PM, EdwardKing wrote: I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. The command sequence ... mysql> create data

Re: mysql Access denied error

Am 05.05.2014 15:26, schrieb Johan De Meersman: > - Original Message - >> From: "Reindl Harald" >> >> i know that, but it does not change the fact that here > > Either you didn't know that but have trouble admitting it; or you did but > conciously chose to be rude and condescending in

Re: mysql Access denied error

- Original Message - > From: "Reindl Harald" > > i know that, but it does not change the fact that here Either you didn't know that but have trouble admitting it; or you did but conciously chose to be rude and condescending instead of helpful. Your choice. In the second scenario, I

Re: mysql Access denied error

Am 05.05.2014 11:12, schrieb Jigal van Hemert: > On 5-5-2014 10:57, Reindl Harald wrote: >> >> >> Am 05.05.2014 10:19, schrieb Manuel Arostegui: >>> 2014-05-05 10:00 GMT+02:00 Reindl Harald >> >: >>> >>> Am 05.05.2014 08:34, schrieb Manuel Arostegui: >>> >

Re: mysql Access denied error

Hi, On 5-5-2014 10:57, Reindl Harald wrote: Am 05.05.2014 10:19, schrieb Manuel Arostegui: 2014-05-05 10:00 GMT+02:00 Reindl Harald mailto:h.rei...@thelounge.net>>: Am 05.05.2014 08:34, schrieb Manuel Arostegui: > "%" doesn't match localhost so if you don't specify it you will be

Re: mysql Access denied error

using > host specific permissions > Good for you. I might be working somewhere bigger than that. Here is what I am talking about: mysql> grant all on hadooptest.* to 'hadoopuser'@'%' identified by '123456'; flush privileges; Query OK, 0 rows affected

Re: mysql Access denied error

Am 05.05.2014 10:19, schrieb Manuel Arostegui: > 2014-05-05 10:00 GMT+02:00 Reindl Harald >: > > Am 05.05.2014 08:34, schrieb Manuel Arostegui: > > "%" doesn't match localhost so if you don't specify it you will be > > attempting to connect via Unix So

Re: mysql Access denied error

2014-05-05 10:00 GMT+02:00 Reindl Harald : > > > Am 05.05.2014 08:34, schrieb Manuel Arostegui: > > "%" doesn't match localhost so if you don't specify it you will be > > attempting to connect via Unix Socket. > > If you don't want to specify -hlocalhost all the time, just do the grant > > with "@

Re: mysql Access denied error

Am 05.05.2014 08:34, schrieb Manuel Arostegui: > "%" doesn't match localhost so if you don't specify it you will be > attempting to connect via Unix Socket. > If you don't want to specify -hlocalhost all the time, just do the grant > with "@localhost" instead of "@%" nonsense % matches *any hos

Re: mysql Access denied error

rror in your SQL syntax; check the manual > that corresponds to your MySQL server version for the right syntax to use > near 'priviledges' at line 1 > mysql> flush privileges; > Query OK, 0 rows affected (0.00 sec) > > mysql> quit; > Bye > > Then I use had

mysql Access denied error

ush privileges; Query OK, 0 rows affected (0.00 sec) mysql> quit; Bye Then I use hadoopuser with password 123456 [hadoop@master ~]$ mysql -u hadoopuser -p Enter password: ERRO

[5.1 Vs 5.5 ] ERROR 1045 (28000): Access denied for user 'testuser'@'Serv1.corp.domain.in' (using password: YES)

%.corp.domain.in| testuser | *FJHHEU5746DDHDUDYDH66488 | +---++---+ and skip_networking is OFF *Mysql Version : 5.1.58-log* root@Serv1:~# mysql -utestuser -p@8AsnM0! -h $(hostname) ERROR 1045 (28000): Acces

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

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

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: Automatic reply: "access denied" to non-root@localhost & null-string user in USER_PRIVILEGES

Hello Round, On 12/27/2012 5:34 AM, Round Square wrote: On 12/26/2012 01:25 PM, Igor Shevtsov wrote: You mysql.user table might be corrupted. If you have access to it as a root user, try check table mysql.user, and repair table mysql.user if table corruption was detected. Alternatively, shut d

Re: Automatic reply: "access denied" to non-root@localhost & null-string user in USER_PRIVILEGES

that might call for that? Thanks! > > > > > > On 26/12/12 18:00, Round Square wrote: >> Hi all: >> Suddenly, after a long, functioning run of the mysql server, all the >> non-root accounts went bad, with: >> >> Access denied for user &#

Re: "access denied" to non-root@localhost & null-string user in USER_PRIVILEGES

mysql user On 26/12/12 18:00, Round Square wrote: Hi all: Suddenly, after a long, functioning run of the mysql server, all the non-root accounts went bad, with: Access denied for user 'non_root_user'@'localhost' (using password: YES) Authenticat

"access denied" to non-root@localhost & null-string user in USER_PRIVILEGES

Hi all: Suddenly, after a long, functioning run of the mysql server, all the non-root accounts went bad, with: Access denied for user 'non_root_user'@'localhost' (using password: YES) Authenticating with "non_root_u...@server.ip.address" still works

Re: mysql_upgrade fails with "Access denied"

>> I'm trying to run mysql_upgrade but I get: >> >> # mysql_upgrade >> Looking for 'mysql' as: mysql >> Looking for 'mysqlcheck' as: mysqlcheck >> Running 'mysqlcheck' with connection arguments: '--port=3306' >&g

Re: mysql_upgrade fails with "Access denied"

un/mysqld/mysqld.sock' mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect FATAL ERROR: Upgrade failed I've also tried specifying my root password with --password and also specifying -u mysql but it still fail

Re: mysql_upgrade fails with "Access denied"

;>>> # mysql_upgrade >>>> Looking for 'mysql' as: mysql >>>> Looking for 'mysqlcheck' as: mysqlcheck >>>> Running 'mysqlcheck' with connection arguments: '--port=3306' >>>> '--socket=/var/run/mysqld/mysqld

Re: mysql_upgrade fails with "Access denied"

k' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect FATAL ER

Re: mysql_upgrade fails with "Access denied"

>> I'm trying to run mysql_upgrade but I get: >> >> # mysql_upgrade >> Looking for 'mysql' as: mysql >> Looking for 'mysqlcheck' as: mysqlcheck >> Running 'mysqlcheck' with connection arguments: '--port=3306' >&g

Re: mysql_upgrade fails with "Access denied"

un/mysqld/mysqld.sock' mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect FATAL ERROR: Upgrade failed I've also tried specifying my root password with --password and also specifying -u mysql but it still

mysql_upgrade fails with "Access denied"

I'm trying to run mysql_upgrade but I get: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' my

Re: Access denied with mysqladmin

Hi, >¶¼ÊÇÖйúÈ˾Í˵ÖÐÎÄ°É^_^ Nice to meet you. But I think that this newsgroup is for the people who come from all of the world. So post topics in English is better for anyone who is also interested about this topic, right? >Ã÷Ìì»á¸üºÃ I like this sentence. Õæ¸ßÐËÄÜÔÚÕâÀï¼ûµ½×Ô¼ºÈË¡£Ï£ÍûÒÔºóÄ

Re: Access denied with mysqladmin

太搞笑了，哈哈 2010/9/25 Neo > 都是中国人就说中文吧^_^ > > > 明天会更好 > > > On Sat, Sep 25, 2010 at 9:21 AM, Ma Xiaoming >wrote: > > > Hi Shawn, > > > > > You forgot to use -- before the option "version". Try this instead > > > > > > mysqladmin --version > > > > > > Let us know your results. > > > > Oh yes, it

Re: Access denied with mysqladmin

都是中国人就说中文吧^_^ 明天会更好 On Sat, Sep 25, 2010 at 9:21 AM, Ma Xiaoming wrote: > Hi Shawn, > > > You forgot to use -- before the option "version". Try this instead > > > > mysqladmin --version > > > > Let us know your results. > > Oh yes, it works. When I typed the right command: mysqladmin --versio

Re: Access denied with mysqladmin

Hi Shawn, > You forgot to use -- before the option "version". Try this instead > > mysqladmin --version > > Let us know your results. Oh yes, it works. When I typed the right command: mysqladmin --version I got the following result: mysqladmin Ver 8.42 Distrib 5.1.50, for Win32 on ia32 Many t

Re: Access denied with mysqladmin

lowing error message: -- C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)' --

Re: Access denied with mysqladmin

Hi, > As the console print,do you enter the password for user "ODBC" correctly? How to correctly use this console application, that is how to pass password when calling this console application? Thanks. > ODBCÓû§ÃÜÂë²»¶Ô£¬ËµµÄºÜÃ÷ÏÔ. ÎÒÊÇÐÂÊÖ£¬»¹²»»áʹÓÃMySQL¡£ÇëÎÊÈçºÎÔÚÔËÐÐmysqladminÕâ¸öÃüÁ

Re: Access denied with mysqladmin

lowing error message: -- C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)' --

Access denied with mysqladmin

-- C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)' -- Why do I get this result? Thanks. Bes

Access denied for phpmyadmin

Hi all, when i m trying to access phpmyadmin it gives the error * #1045 - Access denied for user 'pma'@'localhost' (using password: NO) ** *How could i fix the problem olease help me, Advanced thanx to you. -Regards Ganeswar Mishra Junior Programmer TathyaSoft pvt. ltd. (+91)9438014761

Re: Access denied; you need the RELOAD privilege for this operation

In the last episode (Sep 20), Pete Wilson said: > I'm pretty new to MySql, but not many years ago I was an ISAM guy so I > understand the issues with indexes and on-the-fly inserts. > > I've seen many questions around this error message, "Access denied; you > need

Access denied; you need the RELOAD privilege for this operation

Hi everyone -- I'm pretty new to MySql, but not many years ago I was an ISAM guy so I understand the issues with indexes and on-the-fly inserts. I've seen many questions around this error message, "Access denied; you need the RELOAD privilege for this operation." But

mysqldump.exe gives "Access Denied" for user

7;ve had to change 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

Re: "access denied" error

nks, Jesse - Original Message - From: Jim Lyons To: Jesse Cc: MySQL List Sent: Friday, October 10, 2008 8:28 AM Subject: Re: "access denied" error What is the PHP connect string? Are you connecting to the database you have access to? are you connecting as t

Re: "access denied" error

he password > and after typing it in, I'm in. I can also see the only database I've given > that user access to, and I tried a simple SELECT and it worked fine. > However, when I access the database through the PHP application, I get the > error, "Access denied for use

"access denied" error

password and after typing it in, I'm in. I can also see the only database I've given that user access to, and I tried a simple SELECT and it worked fine. However, when I access the database through the PHP application, I get the error, "Access denied for user 'trucksma_db

Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

;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: 'Acc

Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

sword 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'@'localhost' (using pa

Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

utdown MySQL service from 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'

Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

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 access to port 3306?If a firewall is preventing access how w

mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

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 th

Re: MySQL Error Number 1045 Access denied

o run the > > administer GUI. This should solve the problem. > > CHAVA > > On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney > <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>wrote: > >

Re: MySQL Error Number 1045 Access denied

word and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>wrote: Hello I am still getting

Re: MySQL Error Number 1045 Access denied

you can test with the below solution :- >>> >>> Try to reconfigure MySQL by providing the root password and >>> then >>> try to run the >>> >>> administer GUI. This should solve the problem. >>> >>> CHAVA &g

Re: MySQL Error Number 1045 Access denied

assword and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney <[EMAIL PROTECTED]>wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I at

Re: MySQL Error Number 1045 Access denied

. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney <[EMAIL PROTECTED]>wrote: > Hello > > I am still getting the MySQL Error Number 1045 Access denied error message > when running the adminstrator gui. I attempted to start mysql from the dos > command line via "m

Re: MySQL Error Number 1045 Access denied

TED]>wrote: > Hello > > I am still getting the MySQL Error Number 1045 Access denied error message > when running the adminstrator gui. I attempted to start mysql from the dos > command line via "mysql" and I am getting the following. ERROR 1045 (28000): > Access

MySQL Error Number 1045 Access denied

Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via "mysql" and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'lo

Re: Access denied for user 'debian-sys-maint'@'localhost'

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 '

Re: Access denied for user 'debian-sys-maint'@'localhost'

MySQL normally only checks the privilege tables on start-up. On Mon, 2008-07-21 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'"

Re: Access denied for user 'debian-sys-maint'@'localhost'

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

Access denied for user 'debian-sys-maint'@'localhost'

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

Follow Up : Error in /index.php: Access denied for user 'apache'@'localhost' (using password: NO)

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 re

Re: Error in /index.php: Access denied for user 'apache'@'localhost' (using password: NO)

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 mail

Error in /index.php: Access denied for user 'apache'@'localhost' (using password: NO)

ort of transfer hundreds of times with no trouble but the last two in a row have required that the permissions be reset. I am just looking at the error messages in the emails I am getting and apparently it is not just the Apache user. It is sending access denied for the site account owner too, I just notic

Re: Access denied for GRANT using root yet manual user insertion is fine

I execute the GRANT on _ANY_ database, I receive the following error: > > mysql> GRANT ALL PRIVILEGES ON `foo`.* TO 'root'@'localhost' > IDENTIFIED BY PASSWORD 'MYSQL5_PASSWORD_HASH'; > ERROR 1044 (42000): Access denied for user 'root'@'localhost'

Access denied for GRANT using root yet manual user insertion is fine

localhost' IDENTIFIED BY PASSWORD 'MYSQL5_PASSWORD_HASH' WITH GRANT OPTION | 1 row in set (0.00 sec) When I execute the GRANT on _ANY_ database, I receive the following error: mysql> GRANT ALL PRIVILEGES ON `foo`.* TO 'root'@'localhost' IDENTIFIED BY PASSWOR

Access denied for GRANT using root yet manual user insertion is fine

localhost' IDENTIFIED BY PASSWORD 'MYSQL5_PASSWORD_HASH' WITH GRANT OPTION | 1 row in set (0.00 sec) When I execute the GRANT on _ANY_ database, I receive the following error: mysql> GRANT ALL PRIVILEGES ON `foo`.* TO 'root'@'localhost' IDENTIFIED BY PASSWOR

Re: Access denied for user on Windows Server

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

Re: Access denied for user on Windows Server

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

Access denied for user on Windows Server

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 accoun

Re: Access Denied When Trying to Create Database

2007 4:36:33 PM (GMT-0500) America/New_York Subject: Re: Access Denied When Trying to Create Database Gerald, I tried this and it still didn't work! Raven:~ untz$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 223 to server

Re: Access Denied When Trying to Create Database

Don't you mean this ? grant all privileges on *.* to 'untz'@'localhost' identified by 'maddog'; - Original Message - From: "untz" <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Monday, June 11, 2007 4:36:33 PM (GMT-0500) America

Re: Access Denied When Trying to Create Database

#x27;privileges on *.* to 'untz'@'localhost' identified by 'maddog'' at line 1 mysql> :( Kindest regards, Unnsse On Jun 11, 2007, at 1:28 PM, Gerald L. Clark wrote: untz wrote: Gerald, I tried this and still got an error! mysql> grant all pri

Re: Access Denied When Trying to Create Database

untz wrote: Gerald, I tried this and still got an error! mysql> grant all privileges on *.* to 'untz'@'localhost' identified by 'maddog'; ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using password: YES) mysql> Can

Re: Access Denied When Trying to Create Database

T statement you used Should be "grant super privileges on *.* to 'untz'@'localhost' identified by 'password'; Not "grant super *.* to 'untz'@'localhost' identified by 'password';" Regards, Mikhail Berman -Original Me

Re: Access Denied When Trying to Create Database

Gerald, I tried this and still got an error! mysql> grant all privileges on *.* to 'untz'@'localhost' identified by 'maddog'; ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using password: YES) mysql> Can anyone p

RE: Access Denied When Trying to Create Database

#x27;password';" Regards, Mikhail Berman -Original Message- From: untz [mailto:[EMAIL PROTECTED] Sent: Monday, June 11, 2007 4:02 PM To: Ananda Kumar Cc: mysql@lists.mysql.com Subject: Re: Access Denied When Trying to Create Database Ananda, Thank you for responding!

  1   2   3   4   5   6   7   >