%.corp.domain.in| testuser | *FJHHEU5746DDHDUDYDH66488 |
+---++---+
and skip_networking is OFF
*Mysql Version : 5.1.58-log*
root@Serv1:~# mysql -utestuser -p@8AsnM0! -h $(hostname)
ERROR 1045 (28000): Acces
Hi,
On 21-9-2010 5:25, Tim Thorburn wrote:
Ignore that ... it's amazing how you can solve problems with enough
caffeine and enough time away from a computer screen >.>
It's also amazing how frustrating it is for those who are searching for
the problem you mentioned to only find threads with '
Ignore that ... it's amazing how you can solve problems with enough
caffeine and enough time away from a computer screen >.>
On 9/20/2010 10:58 PM, Tim Thorburn wrote:
Hello,
A few days ago I ran into Error 1045 when attempting to add a new
database user to my development ma
Hello,
A few days ago I ran into Error 1045 when attempting to add a new
database user to my development machine. The error only occurred when
trying to connect to the database as a new user which I found a little
odd. After searching Google I discovered that this error is caused by a
ew-password'
You may have to give the complete path to "mysqladmin".
CheersCassj
-Original Message-
>From: Thibaud Hulin <[EMAIL PROTECTED]>
>Sent: May 9, 2007 4:13 PM
>To: mysql@lists.mysql.com
>Subject: ERROR 1045 (28000): Access denied for user &#
Hi,
I installed mysql 4.1.22 for Debian testing.
I launched the manual installation.
However, when I do :
mysql -u root
I get :
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
I tried to reinstall it, but it fails.
Thanks for help,
s Armstrong <[EMAIL PROTECTED]> wrote:
Hi.
Using mySQL 4.1.22 on Linux, I got this error message suddenly this
morning (it worked ok yesterday):
-
[EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@
Hi.
Using mySQL 4.1.22 on Linux, I got this error message suddenly this
morning (it worked ok yesterday):
-
[EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
---
Hi.
Using mySQL 4.1.22 on Linux, I got this error message suddenly this
morning (it worked ok yesterday):
-
[EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
---
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)
-
Aron Levy wrote:
Hi good afternoon, i am triying to connect with my company's
mysql server using a client program from shell and I keep
receiving the following answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for
ing answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user
'user1'@'200.93.42.209' (using password: YES)
[EMAIL PROTECTED] ~]#
I already checked the user was configured for any host ("%"),
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
I keep receiving the
following answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209'
(using password: YES)
[EMAIL PROTECTED] ~]#
I already checked the user was configured for
11:48 AM, Aron Levy wrote:
Hi good afternoon, i am triying to connect with my company's mysql
server using a client program from shell and I keep receiving the
following answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access deni
Hi good afternoon, i am triying to connect with my company's mysql
server using a client program from shell and I keep receiving the
following answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user 'user1'
or portbld-freebsd5.3 (i386)
>
> [EMAIL PROTECTED] ~> mysql -ubiogeek -p
> Enter password:
>
> mysql> use biogeek;
> Database changed
>
> mysql> LOAD DATA INFILE 'zipcode.data' INTO TABLE zipcodes FIELDS
> TERMINATED BY ',';
> ERROR
[EMAIL PROTECTED] ~> mysql -ubiogeek -p
Enter password:
mysql> use biogeek;
Database changed
mysql> LOAD DATA INFILE 'zipcode.data' INTO TABLE zipcodes FIELDS
TERMINATED BY ',';
ERROR 1045 (28000): Access denied for user 'biogeek'@'localhost'
(using pass
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
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
Good morning,
Im 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 Administator, PhpAdmin, Gestion BDD.
Then I tried to set a password on m
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
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 PROTECT
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: YES
Please help.
[EMAIL PROTECTED]
--
MySQL
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
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
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
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
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
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
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
-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
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
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.
>>
>&
:
> 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 and the problem ap
ed by myself) + REDHAT 9
>
> all I did is:
>
> grant all on privileges on dbname.* to 'auser'@localhost
> identified by "pass"; flush privileges;
>
> and in my PHP, I provide the correct login, password and using
> 'localhost'.
&g
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 th
privileges on dbname.* to 'auser'@localhost identified by
"pass";
flush privileges;
and in my PHP, I provide the correct login, password and using
'localhost'.
it works successfully, however, sometimes it just give me "Error 1045:
Access Denied for user
etly go crazy and or bald.
Does Paul.D. actually HAVE hair? Has anyone met him in person to verify the
existance of strands. lol- ;)
_TheMechE
-Original Message-
From: ike strong [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 22, 2003 12:16 PM
To: [EMAIL PROTECTED]
Subject: Error 104
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
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 1045: Acess denied for user: '[EMAIL PROT
. 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
; 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 the 3.23.57 version in my account and i don't have
>
> root
>
> > privileges.
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
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
>
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
- Jim
> When I start MySQL with "mysql -u root -p" I get again the error 1045
> ("Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)".
> What am I doing wrong ?
>
> - Original Message -
> From: "gerald_clark" <
You are not entering the right password.
If you did NOT set a password for root, then leave the -p option off.
Stephan Wölfel wrote:
When I start MySQL with "mysql -u root -p" I get again the error 1045
("Access denied for user: '[EMAIL PROTECTED]' (Using password: YES
When I start MySQL with "mysql -u root -p" I get again the error 1045
("Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)".
What am I doing wrong ?
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Stepha
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
in. Run:
mysql -u stw -p
...enter the password when prompted, and you're in.
- Jim
On Monday, October 13, 2003, at 11:20 AM, Stephan Wölfel wrote:
thanks for the advise.
What you tell all works. But even after this I still get the same
error 1045
when typing "grant all on *.* to
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
Hi Jim,
thanks for the advise.
What you tell all works. But even after this I still get the same error 1045
when typing "grant all on *.* to stw". Why ?
Stephan
- Original Message -
From: "James Cradock" <[EMAIL PROTECTED]>
To: "Stephan Wölfel" <[
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&
ied a password.
- Jim
On Monday, October 13, 2003, at 10:15 AM, 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 a way to check for
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 a way to check for user datas ? Or how to resolve this
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:
Can anyone tell me what I am doing wrong or need to do with the following.
Using MySQL 4.0.11 gamma, win 2000, j2sdk1.4.1_01 and Tomcat 4.1.
Under mysql, the statement: GRANT ALL PRIVILEGES ON *.* TO
[EMAIL PROTECTED] IDENTIFIED BY 'javadude' WITH GRANT OPTION;
Produces this err
I just recently installed MySQL and when I try and connect I get an
error 1045, Access Denied for user. I am running 3.2.55-nt with
local host via TCP/IP on W2000.
I think it has something to do with the local host, because the error
message returns my [EMAIL PROTECTED] rather than just the
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
1 - 100 of 122 matches
Mail list logo
