I have searched the MySQL Administrator forum for help on this, but no joy.
When I try to conect to a database on Dreamhost, using MySQL Administrator,
I get this error, with a red X in a Windows dialog box:
(The name of the database and and user are changed)
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
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. g
This is sort of off-topic, but hub.org, which operates out of Wolfville,
NS, has shut down the
Hello.
mysqladmin:connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)'
...
shellsafe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid
--skip-grand-tables
[1] 28712
shell Starting
Hi,
I have had to change mysql root passwd
My procedure is just below
shell mysql -u root -p
mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
mysql flush privileges;
and I checked this password another consol I saw MySQL wasn't
accepted new passwd else, it didnt old
Hi,
I have had to change mysql root passwd
My procedure is just below
shell mysql -u root -p
mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
mysql flush privileges;
and I checked this password another consol I saw MySQL wasn't
accepted new passwd else, it
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
User mysqladmin has not the rights to access mysql? How can that be?
Laurent
--
Linux is like an Indian tent: no Windows, no Gates, and an Apache inside!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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
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
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 executable. Did
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.
--
:
# mysql --user=foo --password=password -h host foo
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
I've only managed to find a single thread about this issue which was a
bug in the installation of mysql on RedHat 7. Many months have gone by
since then so I
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
I've only managed to find a single thread about this issue which was a
bug in the installation of mysql on RedHat 7. Many months have gone by
since then so I wonder if this is still the same issue.
--
Marc Tardif
the command-line 'mysql -u abcd'
* I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa'
o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
* As root I have executed 'USE mysql; SELECT USER,PASSWORD FROM USER' and have
verified the password
can login using the command-line 'mysql -u abcd'
* I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa'
o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
* As root I have executed 'USE mysql; SELECT USER,PASSWORD FROM USER' and have
verified
a password
xxyyzzaa
* I can login using the command-line 'mysql -u abcd'
Seems you connected as anonymous user. Check it with SELECT CURRENT_USER() function.
* I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa'
o ERROR 1045: Access denied for user: '[EMAIL PROTECTED
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
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 doing.
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
.
Michael
Pahlevanzadeh Mohsen wrote:
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
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 basically
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.
J.R.
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
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
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:
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
privileges;
Now logout, and login again using the new password and the new user!
voilĂ !
Best Regards!
On Fri, 2004-03-12 at 09:25, Leslie Vance wrote:
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
and I enter it.
Then it beeps and gives me this error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' Using
password: YES
I am at a loss as to what to do.
Please help.
Thanks
Rob
Hello Rob,
Friday, March 12, 2004, 7:39:47 PM, you wrote:
RA ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' Using
password: YES
Does that user actually exist within MySQL? I have you used the
mysqladmin program and created a user account called ackerley? If not,
that's why you can't
Is this user a super user, or do they only have access to a single DB?
If they are a super user, try changing the password using mysqladmin -u
ackerley password 'newpassword'
If this user only has access to a single db, alter your mysql command to:
shell mysql -u ackerley -p 'database_name'
Then like Richard Davey sent earlier to the list, try:
shell mysql -u root
If you haven't created the users yet with the mysql tool, then your user
won't have access to it. First, change the root password using:
shell mysqladmin -u root password 'new_password'
Then log into mysql and use:
mysql
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 denied for user : '@localhost'.
Is this because i'm
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 denied for user : '@localhost'.
Is this because i'm not the root?
If i try to use
,
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 denied for user : '@localhost'.
Is this because i'm
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 PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Error 1045: Access denied...
Hi
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
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]
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
. Howell II [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 1:24 PM
To: [EMAIL PROTECTED]
Subject: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
Hey there all,
Here is the problem I am haveing and was wondering if anyone can help
me here. I
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
.* to 'elmasri'@'%' identified by 'navathe';
Query OK, 0 rows affected (0.00 sec)
mysql quit
Bye
C:\temp\Menagerie_01mysql -u elmasri -pnavathe company
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
===
However if I use only the grant statement,
I don't need any
1045 Access Denied for user:'@127.0.0.1'
(Using password:NO).
I am attempting to setup DBCP and get the above message while trying to
setup the user. (The document for the DBCP setup is at:
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how
to.html, see MySQL DBCP Example
] IDENTIFIED BY 'javadude' WITH GRANT OPTION;
| Produces this error: ERROR 1045 Access Denied for user:'@127.0.0.1'
| (Using password:NO).
|
| I am attempting to setup DBCP and get the above message while trying to
| setup the user. (The document for the DBCP setup is at:
|
http://jakarta.apache.org
the DNS
name on the local machine, I get:
shell mysql -h 192.168.1.24 -u test -p
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
I have even tried connecting using the IP address. I have poured
over the docs, and have tried all the scenarios of add
to localhost, I can connect fine. If
I connect from another machine, or just use the DNS
name on the local machine, I get:
shell mysql -h 192.168.1.24 -u test -p
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
I have even tried connecting using the IP address. I have
coonect to the database without a host, or
with host set to localhost, I can connect fine. If
I connect from another machine, or just use the DNS
name on the local machine, I get:
shell mysql -h 192.168.1.24 -u test -p
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
test -p
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
I have even tried connecting using the IP address. I have poured
over the docs, and have tried all the scenarios of add hostnames
to /etc/hosts etc. I even complied from source (glibc problem).
No luck
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
), 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]:~$ mysql -u depot -h localhost -p
Enter password:
Welcome
]:~$ mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
[EMAIL PROTECTED]:~$ mysql -u depot -h localhost -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5711 to server version: 3.23.55
Type 'help;' or '\h' for help
), 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]:~$ mysql -u depot -h localhost -p
Enter password:
Welcome
|
---
| % | user |
If I coonect to the database without a host, or
with host set to localhost, I can connect fine. If
I connect from another machine, or just use the DNS
name on the local machine, I get:
shell mysql -h 192.168.1.24 -u test -p
ERROR 1045: Access denied for user: '[EMAIL PROTECTED
, or
with host set to localhost, I can connect fine. If
I connect from another machine, or just use the DNS
name on the local machine, I get:
shell mysql -h 192.168.1.24 -u test -p
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
I have even tried connecting using the IP
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
change
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 Reznichenko
Date: Tue, 23 Apr
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.html
TM Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
TM From: Victoria Reznichenko
]
- 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 cannot find any document which can get
me beyond Access denied
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
password:**
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
If you didn't set password, you don't have to use '-p' option for
connection.
If you want to set password, please, chaeck the following link:
http://www.mysql.com/doc/P/a/Passwords.html
[root@omsrh
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
Enter password:**
ERROR 1045: Access denied for user
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 the mysql user.
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 the mysql
]
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 denied for user: [EMAIL PROTECTED]
(using password: YES)
errors. I'm connecting to this MySQL
65 matches
Mail list logo