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

Thibaud... If you have already set your MySQL root password, then you need to login to mysql like this: > mysql -u root -p You should be prompted for the mysql root password. If you haven't set your mysql root password, then you need to do this: > mysqladmin -u root password 'new-password' You m

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, thomas Armstrong <[EMAIL PROTECTED]> wrote: H

Re: Error 1045 - Access denied

Dan, I believe Dreamhost has it MySQL locked down so that only they have primary access, and yes phpMyAdmin is installed on their system. It would be .v. difficult for them to give me rights. This is sort of off-topic, but hub.org, which operates out of Wolfville, NS, has shut down the cent

Re: Error 1045 - Access denied

Miles, can you access the remote database from any other tools on your local machine? mysql command line, etc. You state you can use phpmyadmin, but is that installed at your hosting provider? It's not unusual for hosting providers to lock down their database hosts to only allow access from

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

Thank you very much James, i flush the privilegies and restart the mysql service and all result fine :-) I can access from anyhost Aron L. James Barros wrote: Can this use log in from localhost successfully? Try flushing privileges again? If that failed, I'd drop the user and recreate? ( The

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

Can this use log in from localhost successfully? Try flushing privileges again? If that failed, I'd drop the user and recreate? ( Theres really not alot to this, sorry I don't have any more ideas :( ) -- James On Jun 7, 2006, at 1:07 PM, Aron Levy wrote: Hi James i follow your recomendation and

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

On 6/7/06, Aron Levy <[EMAIL PROTECTED]> wrote: Hi James i follow your recomendation and verify that the hash produced matches the password field in user exactly. -- Aron L. Well, that's weird, should be working. A shot in the dark: try starting your server with "--old-passwords" as an option

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

Hi James i follow your recomendation and verify that the hash produced matches the password field in user exactly. -- Aron L. James Barros wrote: Well, for starters don't worry about ports being open. If you werent able to connect, it would give you a different error message. select passw

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

Well, for starters don't worry about ports being open. If you werent able to connect, it would give you a different error message. select password('yourpassword'); and verify that the hash produced matches the password field in user exactly. -- James On Jun 7, 2006, at 11:48 AM, Aron Levy

Re: 'ERROR 1045 (28000): Access denied' when trying to LOAD DATA INFILE.

Hello. You should have FILE privilege. The FILE privilege is administrative privilege that can only be granted globally (using ON *.* syntax). Jeroen Van Goey <[EMAIL PROTECTED]> wrote: > Hi all, > > I connect via ssh from a Linux RedHat 9 box to a remote FreeBSD > server. There

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

Re: Error 1045

http://dev.mysql.com/doc/mysql/fr/Access_denied.html Philippe Cabet wrote: Good morning, I’m a new Easyphp1-7 user. My computer environnement is Windows XP version 2002 service pack 1. Apache 1.3.27 PHP 4.3.3 PHPMYADMIN 2.5.3 MYSQL 4.0.15 My problem is; With EasyPhp menu, I choise Admini

Re: Error 1045

Asia, Inc. - Original Message - From: "James E Hicks III" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 22, 2004 9:33 PM Subject: Re: Error 1045 my > On Thursday 22 July 2004 09:06 am, Jernej Koprivec wrote: > > My first contact with MySQ

Re: Error 1045

On Thursday 22 July 2004 09:06 am, Jernej Koprivec wrote: > My first contact with MySQL. > When I try to login with the following two lines, I get an error code 1045 > mysql -h localhost -u jk -p ENTER > PASSWORD: password > > ERROR 1045: Access denied for user: [EMAIL PROTECTED] using password: YE

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

Laurent <[EMAIL PROTECTED]> wrote: > User mysqladmin has not the rights to access mysql? How can that be? Have you created the "mysqladmin" user? By default there is no such user and it's not supposed to be there. There is no special meaning for it - mysqladmin usually logs in as "root" user.

RE: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)

Have you tried another user. -Original Message- From: Laurent To: [EMAIL PROTECTED] Sent: 7/19/04 8:07 AM Subject: Re: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (U sing password: YES) On Monday 19 July 2004 14:59, Victor Pendleton wrote: > mysqladmin is an ex

Re: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)

On Mon, 19 Jul 2004, Laurent wrote: > On Monday 19 July 2004 14:59, Victor Pendleton wrote: > > mysqladmin is an executable. Did you set up an user named mysqladmin that > > can connect from the localhost? > > Exactly, it should be able to connect, but it doesn't. Should I change the > name from m

Re: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)

On Monday 19 July 2004 14:59, Victor Pendleton wrote: > mysqladmin is an executable. Did you set up an user named mysqladmin that > can connect from the localhost? Exactly, it should be able to connect, but it doesn't. Should I change the name from mysqladmin to mysql or something similar? I'll t

RE: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)

mysqladmin is an executable. Did you set up an user named mysqladmin that can connect from the localhost? -Original Message- From: Laurent To: [EMAIL PROTECTED] Sent: 7/19/04 6:55 AM Subject: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) User mysqladmin has

Re: ERROR 1045: Access denied for user: 'foo@host' (Using password: YES)

Marc Tardif <[EMAIL PROTECTED]> wrote: > I'm using mysql-3.23.58-1.9 installed from RPM on Red Hat Linux release > 9 (Shrike). First, I create a database and user to connect to this > database using the following commands: > > mysql> CREATE DATABASE foo; > mysql> GRANT ALL PRIVILEGES ON foo.

Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES) SOLVED

Jack Woehr wrote: I figured this out. It's the "ANY" setup in Privileges. Being set to allow ANY user to login without password, MySQL interestingly interprets that as "even known users with passwords MUST log in without passwords." Well, that seems to be the effect, but that's not what it is doi

Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES) SOLVED

I figured this out. It's the "ANY" setup in Privileges. Being set to allow ANY user to login without password, MySQL interestingly interprets that as "even known users with passwords MUST log in without passwords." My two solutions were either to delete the ANY privileges or to create a second ac

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

Jack Woehr <[EMAIL PROTECTED]> wrote: > > I'm having a problem similar to the one mentioned in the list message > http://lists.mysql.com/mysql/165952 > > > * I built, installed, and run MySQL 4.0.18 >o gcc 2.95.3 on Solaris 9 > * I created a user "abcd" and used MyPHPAdmin to give t

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

Jack Woehr wrote: I'm having a problem similar to the one mentioned in the list message http://lists.mysql.com/mysql/165952 * I built, installed, and run MySQL 4.0.18 o gcc 2.95.3 on Solaris 9 * I created a user "abcd" and used MyPHPAdmin to give this user a password "xxyyzzaa"

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

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

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

RE: error 1045 happened randomly

am self compiled: openssl-0.9.7c -Original Message- From: Duncan Hill [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 12:02 AM To: [EMAIL PROTECTED] Subject: Re: error 1045 happened randomly On Monday 01 December 2003 11:46, Francis Mak wrote: > I am using PHP4.3.4 + MY

Re: error 1045 happened randomly

On Monday 01 December 2003 11:46, Francis Mak wrote: > I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary, not rpm and > not compiled by myself) + REDHAT 9 Hmm, I just read this part again.. RedHat 9 is the consistent part between your systems and mine. Wonder if glibc or openssl is at

Re: error 1045 happened randomly

On Monday 01 December 2003 13:08, Francis Mak wrote: > though "blank password" is not a good solution, but at least it fix the > issue. I think I have to go back to previous version, :( > and I am looking forward to use 4.1 stable in my next project, since the > full unicode support. > does mysql

Re: error 1045 happened randomly

On Monday 01 December 2003 12:51, Wouter van Vliet wrote: > don't do that on your production server. Or, in my eyes better yet, > downgrade to the latest stable verion of MySQL. And compile it yourself, .. > always better since it's totally fit for your system then. > And there I was, hoping to ta

RE: error 1045 happened randomly

he DB 100 times. how could you monitor the number of hits?? by using what tools? thank you guys! -Original Message- From: Wouter van Vliet [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 8:52 PM To: 'Francis Mak'; [EMAIL PROTECTED] Subject: RE: error 1045 happened rando

RE: error 1045 happened randomly

Francis Mak wrote: > - I am 100% sure that all scripts are using include > ("db.php"); so all pages are using the same login and > password and hostname > > - since I am using password, so it shows "Using Password YES" as well. > > - The error indeed occured on the same page. e.g. when you > are

RE: error 1045 happened randomly

-TW&lr=&ie=UTF-8&oe=UTF-8&threadm=bkeab v%241bq6%241%40FreeBSD.csie.NCTU.edu.tw -Original Message----- From: Wouter van Vliet [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 8:16 PM To: 'Francis Mak'; [EMAIL PROTECTED] Subject: RE: error 1045 happened

Re: error 1045 happened randomly

On Monday 01 December 2003 12:24, Wouter van Vliet wrote: > Duncan Hill wrote: > > Remove the password from the login and the problem appears to > > go away. I've hammered my test DBs with thousands of serial > > logins, and the problem only shows when a login has a password. > > I'm sory, and I

RE: error 1045 happened randomly

Duncan Hill wrote: > On Monday 01 December 2003 11:46, Francis Mak wrote: > >> it works successfully, however, sometimes it just give me "Error >> 1045: Access Denied for user '[EMAIL PROTECTED]'" >> it happens RANDOMLY. >> >> Could anybody please let me know how to fix this??? > > R

RE: error 1045 happened randomly

Duncan, thanks for your tips. I will give it a try. so this is a known bug in mysql? and for sure using blank password is not a long term solutions, what if it is a share hosting env.? any answer from mysql team? many thanks. francis On Monday 01 December 2003 11:46, Francis Mak wrote: >

RE: error 1045 happened randomly

Francis Mak wrote: > Hi, > > sorry if this has been answered previously, however I > tried to google, I found a few people having this issue, but no > solutions provided. > > I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary, > not rpm and not compiled by myself) + REDHAT 9 > >

Re: error 1045 happened randomly

On Monday 01 December 2003 11:46, Francis Mak wrote: > it works successfully, however, sometimes it just give me "Error 1045: > Access Denied for user '[EMAIL PROTECTED]'" > it happens RANDOMLY. > > Could anybody please let me know how to fix this??? Remove the password from the login

RE: Error 1045: Acess denied for user: 'ODBC@localhost' (Using password: YES)

ike, Well, there are quite a few wierdnessess that I have experienced. One, for instance, is if you are working in the GUI editor interface, and are mucking around with the User priveleges I have actually had the GUI wipe the passwords to null for all rows. I'm sure its just because I'm not

Re: Error 1045: Acess denied for user: 'ODBC@localhost' (Using password: YES)

ike strong <[EMAIL PROTECTED]> wrote: > Can anyone help me to figure out why suddenly I > cant gain access into MySQL database with my password, > which I assigned myself and which was working fine > until yesterday when access was suddenly denied to me > with the following meassage: > > Error 104

Re: Error 1045: Access denied...

. Some of them have said, > "Oh, I just press the power button to shut it off?" > Aaaa! > > Patrick > > -Original Message- > From: Nils Valentin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 12, 2003 8:18 AM > To: [EMAIL PROTEC

Re: Error 1045: Access denied...

wrote: > Nils, > > I have made it a practice to never tell a user to "HIT" anything. "PRESS" > is much safer. > > Patrick > > -Original Message- > From: Nils Valentin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 12, 2003 8:06 AM

Re: Error 1045: Access denied...

Fernando <[EMAIL PROTECTED]> wrote: > Hello, > i've just installed the 3.23.57 version in my account and i don't have root > privileges. The problem is the if i try to create a database, like this > > mysql> create database example; > > i get the following message: > > "Error 1045: Access denie

Fwd: Re: Error 1045: Access denied...

Hi Fernando; you are logged in as anonymous user. log into mysql like this mysql -u root -p Hit enter if no password is set yet. -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ On Thursday 13 November 2003 00:47, Fernando wrote: > Hello, > i've just installe

Fwd: Re: Error 1045: Access denied...

Hi Fernando; you are logged in as anonymous user. log into mysql like this mysql -u root -p Hit enter if no password is set yet. -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ On Thursday 13 November 2003 00:47, Fernando wrote: > Hello, > i've just installe

Re: Error 1045

this helps Thanks Emery - Original Message - From: "Stephan Wölfel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 14, 2003 18:05 Subject: Re: Error 1045 > But MySQL even doesn't ask me for a password but returns immediately this >

Re: Error 1045

But MySQL even doesn't ask me for a password but returns immediately this error. - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "Stephan Wölfel" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 10:14

Re: Error 1045

;[EMAIL PROTECTED]> > To: "Stephan Wölfel" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Monday, October 13, 2003 5:54 PM > Subject: Re: Error 1045 > > >> >> >> Stephan Wölfel wrote: >> >> >Thanks for the adv

Re: Error 1045

)". What am I doing wrong ? - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "Stephan Wölfel" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 5:54 PM Subject: Re: Error 1045 Stephan Wölfel wrote: T

Re: Error 1045

n Wölfel" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 5:54 PM Subject: Re: Error 1045 > > > Stephan Wölfel wrote: > > >Thanks for the advise. > >However I have some additional questions: > >ad 2) How can I check th

Re: Error 1045

nt command. - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "Stephan Wölfel" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 4:47 PM Subject: Re: Error 1045 -- MySQL General Mailing List For list archi

Re: Error 1045

Stephan - Gerald posted good instructions for doing proper privileges, but: Login as root, and execute this command: GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'yourpassword'; This will apply permissions for user stw from host 127.0.0.1. You'll need a password to login. Run: mysql -u

Re: Error 1045

EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 4:47 PM Subject: Re: Error 1045 > 1. The command is not properly formed. > 2. You don't have grant privileges. > 3. Run this as the mysql root user. > > Stephan Wölfel wrote: > > >When I

Re: Error 1045

EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 4:26 PM Subject: Re: Error 1045 Stephan - Connect to MySQL via a shell or command-line, change to the mysql database with use mysql; ...then query the user table: select * from user Also, to connect to the da

Re: Error 1045

1. The command is not properly formed. 2. You don't have grant privileges. 3. Run this as the mysql root user. Stephan Wölfel wrote: When I try to execute "grant all on *.* to stw" where stw is my user name, I get an error 1045 ("Access denied for user: '@127.0.0.1' (Using password: NO). Is there

Re: Error 1045

Stephan - Connect to MySQL via a shell or command-line, change to the mysql database with use mysql; ...then query the user table: select * from user Also, to connect to the database server as a specific user, you'll need to enter mysql -u stw or mysql -u stw -p ...if you specified a pas

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.

Re: ERROR 1045: Access denied for user:

Both ip's are in the user table along with the % wildcard. -- Steve (egrep) On Fri, 7 Mar 2003, gerald_clark wrote: > You grant IP address does not match the IP address of the client failing > the connection. > > Steve Pirk wrote: > > >That was a great suggestion (getting rid of the > >"blank" u

Re: ERROR 1045: Access denied for user:

You grant IP address does not match the IP address of the client failing the connection. Steve Pirk wrote: That was a great suggestion (getting rid of the "blank" user), but alas, it did not work. Here are the three examples: (first one fail because the blank user was removed) [EMAIL PROTECTED]:

Re: ERROR 1045: Access denied for user:

I just installed the standard-4.0.11 binary and the same problem exists. Error 1130: this host is not allowed to connect. Run the grant and flush privs. Access denied... -- Steve (egrep) On Fri, 7 Mar 2003, Steve Pirk wrote: > That was a great suggestion (getting rid of the > "blank" user), but

Re: ERROR 1045: Access denied for user:

That was a great suggestion (getting rid of the "blank" user), but alas, it did not work. Here are the three examples: (first one fail because the blank user was removed) [EMAIL PROTECTED]:~$ mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) [EMAIL PROTECTED]:~$ m

Re: ERROR 1045: Access denied for user:

At 11:07 +1100 3/7/03, Ben Balbo wrote: Hi Steve, Really silly question, but you are reloading the tables once you change the grants, aren't you :-) mysqladmin -p reload B. Yep, it's silly. :-) Because GRANT automatically refreshes the in-memory copies of the grant tables. Steve, try this: mysq

RE: ERROR 1045: Access denied for user:

PM > To: MySQL List > Subject: Re: ERROR 1045: Access denied for user: > > > Hi Steve, > > Really silly question, but you are reloading the tables once you > change the grants, aren't you :-) > > mysqladmin -p reload > > B. > > In response to your

Re: ERROR 1045: Access denied for user:

Tried this... no go... The wierd part, is that localhost works fine, but I cannot connect locally if I use the hostname. Thanks for the help! (maybe I should go back to an old version of mysql :-) -- Steve (egrep) On Fri, 7 Mar 2003, Ben Balbo wrote: > Hi Steve, > > Really silly question, but y

Re: ERROR 1045: Access denied for user:

Did not see a reference to reloading tables in the docs. This is just weird enough for me to vpn in and try again :-) Thanks! -- Steve (egrep) On Fri, 7 Mar 2003, Ben Balbo wrote: > Hi Steve, > > Really silly question, but you are reloading the tables once you > change the grants, aren't you :-)

RE: ERROR 1045: Access denied for user:

Or mysql>> flush privileges; Roger -Original Message- From: Ben Balbo [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 7:08 PM To: MySQL List Subject: Re: ERROR 1045: Access denied for user: Hi Steve, Really silly question, but you are reloading the tables once you chan

Re: ERROR 1045: Access denied for user:

Hi Steve, Really silly question, but you are reloading the tables once you change the grants, aren't you :-) mysqladmin -p reload B. In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM. > Mysql version 3.23.55 Slackware linux 8.0 > Mysql version 3.23.55 OpenBSD > I have tri

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

n name as your MySQL user name." You might also want to check out: http://www.mysql.com/doc/U/s/User_Account_Management.html Gurhan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom McDonough Sent: Thursday, April 25, 2002 10:40 AM To: [EMAIL

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'

Tewfic, Monday, April 22, 2002, 10:07:06 PM, you wrote: >> Hello, i'm having a problem accessing mysql database. I don't recall >> setting a password for root, but when i try to set that password. This is >> happening right after i run mysql_install_db >> >> [root@omsrh etc]# mysql -u root -p

Re: Error 1045 - Access denied

n" <[EMAIL PROTECTED]> To: "Tyler Longren" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]> Sent: Wednesday, December 05, 2001 3:28 PM Subject: RE: Error 1045 - Access denied > > Hello, > > > > I keep on getting "1045 - Access de

RE: Error 1045 - Access denied

> Hello, > > I keep on getting "1045 - Access denied for user: [EMAIL PROTECTED] > (using password: YES)" > errors. I'm connecting to this MySQL server from a remote site. > > I don't see any reason for this. I KNOW that my password is correct. In > the user table, the "Host" is set to % for th