did you flush privileges after setting the password? % stands for wildcard
:)
- Original Message -
From: neal [EMAIL PROTECTED]
To: mySQL [EMAIL PROTECTED]
Sent: Thursday, August 29, 2002 10:47 AM
Subject: RE: JDBC - Access denied REVISED = simply won't accept passwords
when logging
connection attempts.
Neal
-Original Message-
From: neal [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 7:28 PM
To: mySQL
Subject: JDBC - Access denied (using password: yes)
Does anyone know why I would recieve this error, when attmepting to connect
to mySQL via JDBC(driver
Hi all,
I am getting the error when trying to connect server from my client:
ERROR 1044: Access denied for user: '@NRICRIV1.ad.rivenet.com' to database
'mysql'
any answer?
thanks,
anjani
-
Before posting, please check
from my client:
ERROR 1044: Access denied for user: '@NRICRIV1.ad.rivenet.com' to database
'mysql'
any answer?
thanks,
anjani
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
I was able to login and generate a database instance, but then got a little
crazy and tried to automate the starting and stopping of the mysql service.
I copied the mysql.server file to my /etc/init.d directory and then created
the necessary links to the rc0.d and rc3.d directories. When I
Pada Sat, 06 Jul 2002 09:36:27 +0500 (IST)
VINOD [EMAIL PROTECTED] menulis :
I own a domain with MySQL support. I have created a database
lnet_cal on the web and also table yarntype, using PHP Myad-
min on the webspace and also granted all access privileges to
user lnet_root to the
yarntype fields terminated by \',\' \ ;
V mysql_query($query) or
V die(mysql_error());
V // THE ABOVE QUERY HAD DISPLYED THE ERROR AS FOLLOWS
V // \Access denied for user: \'lnet_root@localhost\' (Using pass
V word: YES)\
You must have FILE privilege to use LOAD DATA INFILE. FILE
and the result is displayed on screen and
the loading the text file part(c) I am receiving the following
error in the browser.
Access denied for user: 'lnet_root@localhost' (Using password:
YES)
When I tried to insert the same text file using PHP Myadmin
provided by the web provider, the text
and the result is displayed on screen and
the loading the text file part(c) I am receiving the following
error in the browser.
\Access denied for user: \'lnet_root@localhost\' (Using password:
YES)\
When I tried to insert the same text file using PHP Myadmin
provided by the web provider
and the result is displayed on screen and
the loading the text file part(c) I am receiving the following
error in the browser.
Access denied for user: 'lnet_root@localhost' (Using password:
YES)
When I tried to insert the same text file using PHP Myadmin
provided by the web provider, the text
Hello,
I have a problem that happens periodically on my FreeBSD 4.6 box.
Somehow MySQL (3.23.49) stops responding after some period. It
doesn't allow to connect any user except root ( and it's not because
max_connections, there aren't active connections at the time). The only
thing that
Pada Thu, 4 Jul 2002 10:40:36 +0200
Simas Cepaitis [EMAIL PROTECTED] menulis :
Hello,
I have a problem that happens periodically on my FreeBSD 4.6 box.
Somehow MySQL (3.23.49) stops responding after some period. It
doesn't allow to connect any user except root ( and it's not
Hello,
-Original Message-
From: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 04, 2002 12:44 PM
To: Simas Cepaitis
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL access denied problem
What was the error message appear when you try to log in with
normal user
I've been scowering (sp?) the docs but I can't get past:
mysql use mysql;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql
This happens under any condition where access is needed.
It is after I have done mysql_install_db and chown and there is a user
mysql.
It doesn't
have you run the grant command? this adds users SEPERATE from your unix
user list.
- Original Message -
From: [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 2:39 PM
Subject: Access denied @locahost
I've been scowering (sp?) the docs but I can't get
tlr7425,
Thursday, June 27, 2002, 9:39:33 AM, you wrote:
t I've been scowering (sp?) the docs but I can't get past:
t mysql use mysql;
t ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
t This happens under any condition where access is needed.
t It is after I have done
4:44 AM, Egor Egorov, typed:
tlr7425,
Thursday, June 27, 2002, 9:39:33 AM, you wrote:
t I've been scowering (sp?) the docs but I can't get past:
t mysql use mysql;
t ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
t This happens under any condition where access
3:55 AM
To: [EMAIL PROTECTED]
Subject: Re: Re: Re: Access denied @locahost
Hello tlr7425,
Thursday, June 27, 2002, 12:29:10 PM, you wrote:
Please, don't write me. Send your question in the mail-list.
tgafe mysql will start and it is running and i can get the prompt:
mysql
tgafe but i can't do
to add:
mysql -u root -p mysql
It still just sits,...
[root@RR davidwri]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
I did Set the password, based on the following syntax example (with my value
On Fri, 21 Jun 2002 03:59:33 -0400
david [EMAIL PROTECTED] wrote:
[root@RR davidwri]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
[root@RR davidwri]# mysql -u root -p mysql
Enter password
mysql
It still just sits,...
That's right. You didn't get your prompt back as you wrote earlier.
[root@RR davidwri]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
You tell the mysql client
I am not sure if a Java JDBC error is appropriate for this list or not. If
not, I apologize in advance.
I'm getting the error below that I'm trying figure out where to start
researching... Invalid authorization- access denied for user...
This seems strange b/c I'm using root as username
, 123456);
if (!$db)
{
echo Error : Can't Connect !. Try Later.;
exit;
// After these line mysql exits with error Access Denied . If I check
// admin@localhost with phpMyAdmin it has all permissions granted.
// What's wrong ??
}
$date = date(U);
mysql_select_db(ermitage);
$query = insert
Hi,
Try using the following command:
mysql -u root -p database_name
Where database_name is the name of the database you wish to use.
If everything works you will get the password prompt:
[root@nms-des root]# mysql -u root -p telefonia
Enter password:
Then put your root password (by default
Add -p to the command line.
[localhost:/Users/cooldaze] root# mysql -p
On Tuesday 11 June 2002 09:30, Colin Cooler wrote:
When I try to connect to mysql as 'root' I get the following:
[localhost:/Users/cooldaze] root# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using
Thank you Ray, this worked!
Colin
on 6/11/02 2:59 PM, Ray at [EMAIL PROTECTED] wrote:
mysql --password
(or just -p)
On Tuesday 11 June 2002 7:30, you wrote:
When I try to connect to mysql as 'root' I get the following:
[localhost:/Users/cooldaze] root# mysql
ERROR 1045: Access denied
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO)
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document
screens.
On Thursday 06 June 2002 8:39, you wrote:
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO)
The error occurred while processing an element
Ray,
Thursday, June 06, 2002, 4:39:11 PM, you wrote:
R Error Occurred While Processing Request
R Error Diagnostic Information
R ODBC Error Code = S1000 (General error)
R [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO)
R The error occurred while processing
Processing Request
R Error Diagnostic Information
R ODBC Error Code = S1000 (General error)
R [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password:
NO)
R The error occurred while processing an element with a general identifier
of R (CFQUERY), occupying document position (3:1) to (4
GRANT)
you should do FLUSH PRIVILEGES or mysqladmin reload.
M I think what I should have done is typed - update user SET password =
M PASSWORD(somepassword) where user =root.
Yes.
M Now I can't get into mysql at all as root, with the password I set.
M I get the error message Access denied
% mysqladmin -u root status
% mysqladmin -u root reload
I think what I should have done is typed - update user SET password =
PASSWORD(somepassword) where user =root.
Now I can't get into mysql at all as root, with the password I set.
I get the error message Access denied for user 'root@localhost' (using
% mysqladmin -u root status % mysqladmin -u root reload
I think what I should have done is typed - update user SET password =
PASSWORD(somepassword) where user =root.
Now I can't get into mysql at all as root, with the password I set.
I get the error message Access denied for user 'root@localhost' (using
user =root.
Now I can't get into mysql at all as root, with the password I set.
I get the error message Access denied for user 'root@localhost' (using
password =YES)
I have tried to restart mysql with the --skip-grant-tables option but I
still can't get in as root?
How do I fix this? Can
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all, I'm getting intermittent 'Access denied' errors when running a
php script to admin a mysql db. I've looked in the manual but cannot
work out why I can connect in some parts of the script and not in others
Perhaps there is some common
Nick,
Monday, May 06, 2002, 1:30:22 PM, you wrote:
NW Hi all, I'm getting intermittent 'Access denied' errors when running a
NW php script to admin a mysql db. I've looked in the manual but cannot
NW work out why I can connect in some parts of the script and not in others
NW Perhaps
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Egor Egorov declared
Access denied error occurs when you have no required privileges to
connect to the MySQL server. You gave incomplete error message and I
can't give you detailed answer. Please, check the following
link, you can
To: [EMAIL PROTECTED]
Subject: Access denied irregularities
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all, I'm getting intermittent 'Access denied' errors when running a
php script to admin a mysql db. I've looked in the manual but cannot
work out why I can connect in some parts of the script
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Gurhan Ozen declared
Make sure that the user + host combination you are giving has privileges
in the MySQL server you are trying to connect. You may wanna check user
table in the mysql database.
Well, there must be privileges
Nick,
Monday, May 06, 2002, 3:58:34 PM, you wrote:
NW * and then Egor Egorov declared
Access denied error occurs when you have no required privileges to
connect to the MySQL server. You gave incomplete error message and I
can't give you detailed answer. Please, check the following
link
Isnt it
GRANT ALL ON college.* TO someuser identified BY somepassword;
-Original Message-
From: J [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 28 April 2002 2:22 AM
To: [EMAIL PROTECTED]
Subject: Problem with User Account - access denied
I created and user, like below, using mysql on my
I created and user, like below, using mysql on my
Linux machine (Linux-Mandrake 8.1) to access a
database called college:
GRANT ALL ON college.* TO someuser BY somepassword;
But I'm denied access even from localhost. I tried the
following too:
GRANT ALL ON college.* TO someuser@% BY
TERMINATED BY ',';
It generates the following error:-
ERROR 1045: Access denied for user
netaps@NETAPS1(Using Password: YES)
but now if i executete command as :-
mysql --user=netaps --password=netaps
--host=192.168.100.2 --port=3306 --database=netaps
--execute=select count(*) from jobbatch;
It works
:\\NetapsFiles\\jobsequence.csv' INTO TABLE
AL jobsequence FIELDS TERMINATED BY ',';
AL It generates the following error:-
AL ERROR 1045: Access denied for user
AL netaps@NETAPS1(Using Password: YES)
AL but now if i executete command as :-
AL mysql --user=netaps --password=netaps
AL --host
the following command from
D:\mysql\bin mysql --user=netaps --password=netaps --host=192.168.100.2
--port=3306 --database=netaps --execute=LOAD DATA INFILE
'D:\\NetapsFiles\\jobsequence.csv' INTO TABLE jobsequence FIELDS
TERMINATED BY ',';
It generates the following error:-
ERROR 1045: Access denied
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
Tom,
Thursday, April 25, 2002, 5:40:11 PM, you wrote:
TM I am having the same problem and cannot find any document which can get
TM me beyond Access denied...
TM Could you explain the difference between Linux 'root' user and 'root'
TM user in MySQL?
MySQL user 'root' is usual user, it's a user
Error : Connection Error
Error Number: 1045 Access denied for user: 'us10178a@mybox' (Using password: YES)
Connecting to the database from the command prompt is working, so it's
not a password problem.
Does anyone have an idea on how to solve this?
Thanks in advance!
Regards,
Jasper
]
- 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
Message-
From: Jasper Metselaar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 12:29 PM
To: [EMAIL PROTECTED]
Subject: Access denied when connecting to database from PHP
Hi,
I just compiled Apache 1.3.24 with PHP 4.1.2 with ./configure'
'--with-mysql' '--with-apache
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
Description:
I just now installed MySQL latest version and I cannot acced the database, even though
the MySQLd daemon is running.
How-To-Repeat:
Fix:
Submitter-Id: [EMAIL PROTECTED]
Originator:root
Organization:
MySQL support: [none | licence | email support |
exit
Bye
then I login as ps_user
/ps_ap/mysql mysql -h ps -u push
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.49a-log
Type 'help;' or '\h' for help.
mysql use ps_db
ERROR 1044: Access denied for user: '@ps' to database 'ps_db
1044: Access denied for user: '@ps' to database 'ps_db'
mysql
and cannot use the database, what had I missed out for the privilege
setting?
thank you for reading
Borus
-
Before posting, please check:
http://www.mysql.com
to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.49a-log
Type 'help;' or '\h' for help.
mysql use ps_db
ERROR 1044: Access denied for user: '@ps' to database 'ps_db'
mysql
and cannot use the database, what had I missed out for the privilege
Description:
Access denied errores, for the replication user, are not reported in:
SHOW SLAVE STATUS;
They show all relevant information, and queries like:
CHANGE MASTER TO
report no error.
Subsequent LOAD TABLE % FROM MASTER queries, hang indefinetely
? I have hard time to find the copy to download.
Jane
- Original Message -
From: Steven Hajducko [EMAIL PROTECTED]
To: Jane Tsai [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 5:43 PM
Subject: Re: Access Denied
Did you run the mysql_install_db?
http
http://www.mysql.com/downloads/api-dbi.html
-Original Message-
From: Jane Tsai [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 9:12 AM
To: Steven Hajducko
Cc: [EMAIL PROTECTED]
Subject: Re: Access Denied
Steve,
Thanks for help.
To unpack the test/benchmarks RPM files:
rpm -i
not properly
installed?
Thanks for you help.
Jane
- Original Message -
From: BJ Phillips [EMAIL PROTECTED]
To: Jane Tsai [EMAIL PROTECTED]; Steven Hajducko [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, April 12, 2002 12:35 PM
Subject: RE: Access Denied
http://www.mysql.com/downloads
Hello, All:
Once I complete the installation, I try to set up password for root user:
/usr/bin/mysqladmin -u root -p password 'mypassword'
It did prompt me for new password, I reentered. But I got error back:
Connect to server at 'localhost' failed.
Error: Access denied for user root
prompt me for new password, I reentered. But I got error back:
Connect to server at 'localhost' failed.
Error: Access denied for user root@localhost (using password: yes).
How can I fix this problem? Thanks in advance for help.
Jane Tsai
[EMAIL PROTECTED
error back:
Connect to server at 'localhost' failed.
Error: Access denied for user root@localhost (using password: yes).
How can I fix this problem? Thanks in advance for help.
Jane Tsai
[EMAIL PROTECTED]
-
Before posting
I'm learning mySQL and I think I missed something or
missconfigured...because I get an Access denied error. Any hints what I am
missing? What should I check?
OS: OpenBSD 3.0
# ./mysqladmin -u root -p ver
Enter password:
./mysqladmin Ver 8.23 Distrib 3.23.49, for unknown-openbsd3.0 on i386
You must specify the -p to the mysql, so it prompts you for a password.
I'm learning mySQL and I think I missed something or
missconfigured...because I get an Access denied error. Any hints what I am
missing? What should I check?
mysql -u root mysql
ERROR 1045: Access denied for user
Hello list,
I am attempting to run:
perl -MCPAN -e 'install DBD::mysql'
I am having a similar problem as the message that is in this subject line,
reported by Jon Ingason in a message dated March 1, 2002. I must have
tried the install routine at least 15 times, varying different settings that
--- Kathy Reyes [EMAIL PROTECTED] wrote:
Now I have a different problem. When I type mysql it
gives me the message
Access denied for user: 'root@localhost' (Using
password: NO)
how do I get it to use the password.
When I type mysql -u root -p
I get in...
^
What do you mean? Can
Kathy,
Thursday, March 21, 2002, 7:48:10 PM, you wrote:
KR I just gave up, everything that I tried did not work.
KR I killed mysql and then
KR started with safe_mysql --skip-grant-tables
KR then I was able to connect to mysql without an error.
KR But when I tried to
KR Grant all on mysql.*
On Thu, Mar 21, 2002 at 08:13:16PM -0500, alan4100 wrote:
mysql
Hi Colin,
I wish I can be able to live chat with you, but because of my hearing impaired...it
would not be possible..But what is the real problem? A few days ago I got assistance
from others on my Mysql problem. It has
mysql
Brian,
Fine...lots of typing.:)
Kathy,
Wednesday, March 20, 2002, 7:27:31 PM, you wrote:
KR I cant figure out how I have lost access to 'mysql' (default) database. When
KR I attempt to use mysql on my Linux machine I get the error message ERROR
KR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Kathy
access to 'mysql'
(default) database. When
I attempt to use mysql on my Linux machine I get the
error message ERROR
1045: Access denied for user: 'root@localhost'
(Using password: NO)
How ever I can login using kreyes and ODBC.
Can anyone please tell me where I can find that
my.cnf file
mysql
Hello Kathy,
How have you made out with access to mysql?
Command.
- Original Message -
From: alan4100 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 11:07 AM
Subject: Re: Access denied on use mysql;
mysql
Hello Kathy,
How have you made out with access to mysql
mysql
Kathy,
I see..
Now I have a different problem. When I type mysql it gives me the message
Access denied for user: 'root@localhost' (Using password: NO)
how do I get it to use the password.
When I type mysql -u root -p
I get in...
- Original Message -
From: alan4100 [EMAIL PROTECTED]
To: Kathy Reyes
: Re: Access denied on use mysql;
mysql
Hello Kathy,
How have you made out with access to mysql?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
mysql
Kathy..
Check version of mySQL for me.
Did you said after typing mysql -u root -p, you get in fine?
Then you type mysql? then access denied...
Is this in a sequence?
- Original Message -
From: Kathy Reyes [EMAIL PROTECTED]
To: alan4100 [EMAIL PROTECTED]; mysql [EMAIL PROTECTED
mysql
kathy,
What would happen if you type in
mysql -u root -p
then type in
use mysql
alan,
Given the large amount of postings you've made to this list, I suggest
that you may be bettered helped via live chat.
You can do so by using the mysqldeveloper.com Live Chat system:
http://www.mysqldeveloper.com/chat/
which connects you to the #mysql support channel on the EFnet IRC
mysql
Hi Colin,
I wish I can be able to live chat with you, but because of my hearing impaired...it
would not be possible..But what is the real problem? A few days ago I got assistance
from others on my Mysql problem. It has been fixed and everything works fine.
But I am still having
. It will display ACCESS denied.
Same problems with first and second installation. The second installation
was not necessary; you said you said waste of time. I am not going to
disagree on that, either. But the NT server from the first installation must
have still been running in the background
have lost complete access to 'mysql' datebase
- Original Message -
From: alan4100 [EMAIL PROTECTED]
To: Joel Rees [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 9:30 AM
Subject: Re: Access denied on use mysql;
Joel,
I have read the manual related to windows
, 2002 12:30 AM
Subject: Re: Access denied on use mysql;
Hi Alan,
I am using mysql on linux, so I suggest you
to send cc to the list, let others help you.
How do you get into mysql? Hope ur doing the
following.
$mysql -u root -p
Since you dont have the password you can use
$mysql
closing
and starting SERVER several times, it at last accepts my mysql -u root or
mysql -u root -p with no ACCESS DENIED messages anymore.
- Original Message -
From: Ahmed S K Anis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 10:00 AM
Subject: Re: Access denied
Odd, I think it does a very good job of helping troubleshoot:
http://www.mysql.com/doc/A/c/Access_denied.html
On Wed, 20 Mar 2002 09:30:48 -0500, alan4100 wrote:
And does not explain at all when mysql -u root -p does not work.
: Access denied on use mysql;
I've tried everything thats in this email and nothing seems to work for
me.
I think my situation is a little different because I had access to my
database originally but now I cant connect I can sign on as kreyes but I
cant sign on as root. I can even sign in as ODBC
have lost complete access to 'mysql' datebase
- Original Message -
From: alan4100 [EMAIL PROTECTED]
To: Liyju Janardhan [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 10:26 AM
Subject: Re: Access denied on use mysql;
Hi Liyju,
Before answering your note, I need
:54 AM
Subject: Re: Access denied on use mysql;
I signed in as follows
mysql -h localhost -u kreyes.
mysql is installed on a linux machine and I am connecting remotely from a
Windows 2000 machine. When I had access as root I was able to add users
and
grants. I didnt give myself access
I thought I was sending my email to the [EMAIL PROTECTED] but I guess I
wasnt.
Thank you so much for your help Alan,
I cant figure out how I have lost access to 'mysql' (default) database. When
I attempt to use mysql on my Linux machine I get the error message ERROR
1045: Access denied for user
.
4.2.11 Causes of Access denied Errors
If you encounter Access denied errors when you try to connect to the MySQL
server, the list below indicates some courses of action you can take to
correct the problem:
a.. After installing MySQL, did you run the mysql_install_db script to set
up the initial grant
at 'localhost' failed
V error: 'Access denied for user: 'root@localhost' (Using password: NO)'
V /usr/bin/mysqladmin: connect to server at 'localhost' failed
V error: 'Access denied for user: 'root@localhost' (Using password: NO)'
V What does MySQL have to do with log rotation? How do I get
I dont know what I have done now but I have locked myself out of mysql. When
I type mysql I get an access violation. At first I thought it might have
been something on my end since I am a remote user. But when I attempt to
enter mysql from linux box. I get the same access violation...
Please
localhost -u ODBC
Okay, you logged on as your ODBC driver.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19 to server version: 3.23.44-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql use mysql
ERROR 1044: Access denied for user
The problem begins when I type in use mysql;
Please look at the very left edge with three asterisks..*** where I marked. ACCESS
denied
Hope it will be fixed with your help so I can mind my own chores.
==
C:\mysql\binnet start mysql
The MySql service
I'm having trouble with Apache dying after log rotation and have tracked
it down to the mssqladmin. When I try the:
/usr/sbin/logrotate -f /etc/logrotate.conf
I get the following error:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root
It looks like you need a root kit. No. A root canal. No, wait! That's not
right, either. ;)
alan4100 queried:
[snipped]
C:\mysql\binmysql
[snipped]
***mysql use mysql;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
I know the manual takes a lot of reading
--- alan4100 [EMAIL PROTECTED] wrote:
The problem begins when I type in use mysql;
Please look at the very left edge with three
asterisks..*** where I marked. ACCESS denied
Hope it will be fixed with your help so I can mind
my own chores.
==
C
Rob,
Thursday, March 14, 2002, 10:15:54 PM, you wrote:
Show me the output of the following:
SHOW GRANTS FOR 'username'@'hostname';
RQ output:
RQ mysql show grants for 'root@localhost';
RQ ERROR 1064: You have an error in your SQL syntax near
RQ 'grants for 'root@localhost'' at line 1
RQ
401 - 500 of 580 matches
Mail list logo