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: 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: 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: Access denied...

" is much safer. > > > > Patrick > > > > -Original Message- > > From: Nils Valentin [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, November 12, 2003 8:06 AM > > To: [EMAIL PROTECTED] > > Subject: Fwd: Re: Error 1045: Access denied...

Re: Error 1045: Access denied...

> To: [EMAIL PROTECTED] > Subject: 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 > >

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

PROTECTED] Subject: Re: ERROR 1045: Access denied for user: 'root@localhost' I am having the same problem and cannot find any document which can get me beyond Access denied... Could you explain the difference between Linux 'root' user and 'root' user in MySQL? Subje

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

[EMAIL PROTECTED] - Original Message - From: Tom McDonough <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 5:40 PM Subject: Re: ERROR 1045: Access denied for user: 'root@localhost' > I am having the same problem and ca

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

'root' user in Linux is a "superuser" of OS, not of MySQL. Look at the MySQL documentation, there are a LOT a of info about privilege system in MySQL: http://www.mysql.com/doc/P/r/Privilege_system.html http://www.mysql.com/doc/U/s/User_Account_Management.htm

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

I am having the same problem and cannot find any document which can get me beyond Access denied... Could you explain the difference between Linux 'root' user and 'root' user in MySQL? Subject: Re: ERROR 1045: Access denied for user: 'root@localhost' From: Victoria

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

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