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
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
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.
--
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.* TO
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
* I
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 this user a
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.
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
http://www.mysql.com/doc/en/Resetting_permissions.html in the manual.
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
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:
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
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 installed
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
To: [EMAIL PROTECTED]
Subject: Fwd: Re: Error 1045: Access
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]
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.
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
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 :-)
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 you
Yep, tried that... but I will try it again...
--
Steve (egrep)
On Thu, 6 Mar 2003, Roger Davis wrote:
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
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:
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]:~$
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
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
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 user), but
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 tried
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
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
Enter
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
44 matches
Mail list logo