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
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
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)
-
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
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
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 di
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 o
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.
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
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
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
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
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]
hen, I try to connect to the database using the host parameter but I
> get the following error message:
>
> # mysql --user=foo --password=password -h host foo
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
>
> I've only mana
# 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 the
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
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
"abcd" and used MyPHPAdmin to give this user 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
word
"xxyyzzaa"
* I 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 execut
aa"
* I 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; SEL
ons.html> in the manual.
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,M
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
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
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
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.
>
>
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
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
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
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'
J.
Hello Rob,
Friday, March 12, 2004, 7:39:47 PM, you wrote:
RA> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' >
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
d I enter it.
Then it beeps and gives me this error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
I am at a loss as to what to do.
Please help.
Thanks
Rob
se mysql
delete from user where User='root';
flush 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
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
" 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...
> 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
>
>
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 fol
x27;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 : '@loca
x27;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 : '@loca
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
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]
> 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
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
rry M. 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
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 ans
x27;elmasri'@'localhost' identified by
'navathe';
Query OK, 0 rows affected (0.02 sec)
mysql> grant all on company.* to 'elmasri'@'%' identified by 'navathe';
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
C:\temp\Menagerie_01>mysql
] 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:
or: 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/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how
to.h
tting 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]
PROTECTED]:~$ 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
quot; 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]:~$
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: N
ther machine, or just use the DNS
name on the local machine, I get:
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 o
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
shows:
> > | Host| User |
> > ---
> > | % | user |
>
> > If I coonect to the database without a host, or
> > with host set to localhost, I can connect fine. If
> > I connect f
> > | % | 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 mac
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
--
> | % | 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:
> mysql -h 192.168.1.24 -u t
hows:
| Host| User |
---
| % | 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:
mysql -h 192.168.1.24 -u test -p
E
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
[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
'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
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
>> [root@omsrh etc]# mysql -u root -p
>> Enter 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,
> 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:******
>
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
> 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
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
67 matches
Mail list logo
