untz wrote:
Gerald,
I tried this and still got an error!
mysql grant all privileges on *.* to 'untz'@'localhost' identified by
'maddog';
ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using
password: YES)
mysql
Can anyone please help me? I am unable to use MySQL at all
'' at line 1
mysql
:(
Kindest regards,
Unnsse
On Jun 11, 2007, at 1:28 PM, Gerald L. Clark wrote:
untz wrote:
Gerald,
I tried this and still got an error!
mysql grant all privileges on *.* to 'untz'@'localhost'
identified by 'maddog';
ERROR 1045 (28000): Access denied for user
'untz
Don't you mean this ?
grant all privileges on *.* to 'untz'@'localhost' identified by 'maddog';
- Original Message -
From: untz [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, June 11, 2007 4:36:33 PM (GMT-0500) America/New_York
Subject: Re: Access Denied When Trying to Create
'
identified by 'maddog'' at line 1
mysql
:(
Kindest regards,
Unnsse
On Jun 11, 2007, at 1:28 PM, Gerald L. Clark wrote:
untz wrote:
Gerald,
I tried this and still got an error!
mysql grant all privileges on *.* to 'untz'@'localhost'
identified by 'maddog';
ERROR 1045 (28000): Access denied
: 5.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql create database people_development;
ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to
database 'people_development'
mysql
What could I be possibly be doing wrong?
Many, many thanks,
untz
--
MySQL
to server version: 5.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql create database people_development;
ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to
database 'people_development'
mysql
Try running SHOW GRANTS while logged in, and see what
'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql create database people_development;
ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to
database 'people_development'
mysql
Try running SHOW GRANTS while logged in, and see what privileges
you have. You probably need
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,
Thibaud.
--
MySQL
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 'root'@'localhost' (using
password: NO)
Hi,
I installed mysql
Hi,
When I try mysql_upgrade I get a connection problem,
$ mysql_upgrade -p
Enter password:
/usr/bin/mysqlcheck: Got error: 1045: Access denied for user
'root'@'localhost' (using password: YES) when trying to connect
Error executing '/usr/bin/mysqlcheck --check
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)
--
I created
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)
--
I created
.
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)
--
I created a '/root
Hello,
I get an error message when I start Query Browser.
Could not fetch Catalogs/Schema data.
The following error occured: Access denied; you need the SHOW DATABASES
priviliege for this operation.
My hosting provider has started their server with --skip-show-database.
Is it possible to get
)
---
Could not connect to the specified instance.
MySQL Error Number 1045
Access denied for user'xxxtest'@'pc-24-222-199-71.cpe.rushcomm.ca'(using
password: YES)
If you want to check the network connection, please click the PING button
[OK] [PING
to the specified instance.
MySQL Error Number 1045
Access denied for user'xxxtest'@'pc-24-222-199-71.cpe.rushcomm.ca'(using
password: YES)
If you want to check the network connection, please click the PING button
[OK] [PING
this error, with a red X in a Windows dialog box:
(The name of the database and and user are changed)
---
Could not connect to the specified instance.
MySQL Error Number 1045
Access denied for user'xxxtest'@'pc-24-222-199-71
Hi ALL
I am faced with a issue of creating database , The issue is I am able
to enter to the MySQL Server with the password, but when i try to
create database I get Access Denied
Below are the details
[EMAIL PROTECTED] root]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor
faced with a issue of creating database , The issue is I am able
to enter to the MySQL Server with the password, but when i try to
create database I get Access Denied
Below are the details
[EMAIL PROTECTED] root]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end
you out.
Kaushal Shriyan wrote:
Hi ALL
I am faced with a issue of creating database , The issue is I am able
to enter to the MySQL Server with the password, but when i try to
create database I get Access Denied
Below are the details
[EMAIL PROTECTED] root]# mysql -u root -p
Enter password
Kaushal Shriyan schrieb:
Hi ALL
I am faced with a issue of creating database , The issue is I am able
to enter to the MySQL Server with the password, but when i try to
create database I get Access Denied
Below are the details
[EMAIL PROTECTED] root]# mysql -u root -p
Enter password:
Welcome
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'@'200.93.42.209
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'@'200.93.42.209
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 user
'user1
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 any host (%), the
port 3306 is open
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
] ~]# 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 (%),
the port 3306 is open (checked with nmap), but i dont know
with the following
syntax:
S:\MySQL Server 4.1\binmysql -u dba bugs -p -h hostname
(The password (-p) is the same in steps 3,4 5.
I get the following:
ERROR 1045 (28000): Access denied for user 'dba'@'XP0406OEM' (using password:
YES)
I have 2 questions:
1. Why can't I signon to the bugs
sec)
5. I exit and try to sign back into the bugs database as dba with
the following syntax:
S:\MySQL Server 4.1\binmysql -u dba bugs -p -h hostname
(The password (-p) is the same in steps 3,4 5.
I get the following:
ERROR 1045 (28000): Access denied for user 'dba
. I exit and try to sign back into the bugs database as dba with the
following syntax:
S:\MySQL Server 4.1\binmysql -u dba bugs -p -h hostname
(The password (-p) is the same in steps 3,4 5.
I get the following:
ERROR 1045 (28000): Access denied for user 'dba'@'XP0406OEM
I get the following:
ERROR 1045 (28000): Access denied for user
'dba'@'XP0406OEM' (using password: YES)
Did you do FLUSH PRIVILEGES as root after you performed the GRANT?
I don't think that's the problem. You only need to FLUSH PRIVILEGES
when you update the privilege tables directly
Hello,
I upgraded MySQL from 4.1 to 5.0 on my machine (MDK 2006). Since I can't
connect, I always get:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
(or using password:YES)
I followed the reset password procedure. If the server is started with
--skip-grant
-denied.html
M wrote:
Hello,
I upgraded MySQL from 4.1 to 5.0 on my machine (MDK 2006). Since I can't
connect, I always get:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
(or using password:YES)
I followed the reset password procedure. If the server
' failed
error: 'Access denied for user 'webuser' @localhost (using password:NO)'
I haven't set up any accounts or anything, because I'm following the
manual in order. What should I do here to set up an account and get this
working?
Thanks.
Thom Hehl
Heavyweight Software for Heavyweight
OK, I've just installed the MySQL server and client version 5.0.18 on RH
EL4. I was following through the manual and it says I should test
connectivity by entering mysqladmin version. I tried this, but got this
error:
connect to server 'localhost' failed
error: 'Access denied for user
Is there any way I can change passwd of database without knowing the
administrator .
I'm unable to get into the mysql prompt due to access denied message.I want to
change passwd.How to do this? After change passwd do you think we need to grant
some priviledges?
thanks
Anoop kumar V [EMAIL
hi ,
see -skip-grant-tables in dev.mysql.com/doc
Mathias
Selon Seena Blace [EMAIL PROTECTED]:
Is there any way I can change passwd of database without knowing the
administrator .
I'm unable to get into the mysql prompt due to access denied message.I want
to change passwd.How to do
error when trying to connect mysql.
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
or
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
What could be reason?
Is there any way I can connect to database without changing passwd
1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
or
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
What could be reason?
Is there any way I can connect to database without changing passwd?
thanks
Hi,
I have been noticing following error when trying to connect mysql.
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
or
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
What could be reason?
Is there any way I can connect
run MySQL and successfully add/remove tables etc.
However, when I tried to upload a comma separated value file, I got an
access denied error, although all privileges are granted to my
account. What should I do/am I doing wrong?
[EMAIL PROTECTED] jeroen]$ uname -rs
Linux 2.4.21-4
Hi all,
I connect via ssh from a Linux RedHat 9 box to a remote FreeBSD
server. There I can run MySQL and successfully add/remove tables etc.
However, when I tried to upload a comma separated value file, I got an
access denied error, although all privileges are granted to my
account. What should
message would be the one that I'm getting?
Thanx in advance,
Jorge
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
Date: Mon, 18 Apr 2005 18:38:54 +0300
Hello.
It is strange that refusing message says
Hello.
Could be that the connect command fails, then I start trying and trying,
and then the server blocks because it receives too many connections? Then
the error message would be the one that I'm getting?
I also thought about this and therefore I gave you that advice. What
is
I have a web application running with Apache with PHP 4.1.2 (revision
7.2.6) and MySQL 3.23.58.
The access from the PHP code to the MySQL server using the IP of the
machine with MySQL, an username and a password, and it works fine.
But sometimes we get the MySQL error:
Access denied
(revision
7.2.6) and MySQL 3.23.58.
The access from the PHP code to the MySQL server using the IP of the
machine with MySQL, an username and a password, and it works fine.
But sometimes we get the MySQL error:
Access denied for user: '[EMAIL PROTECTED]' (Using password
, April 16, 2005 5:08 AM
Subject: Access denied-phpMyAdmin
Hi All,
I can access the database from the terminal on Fedora 3,
[EMAIL PROTECTED] bin]# ./mysql -h localhost -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL
and make sure that they correspond to the information
given by the administrator of the MySQL server.
|#1045 - Access denied for user 'root'@'localhost' (using password: YES)
I don't understand this. What have I missed..?
$cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin-2.6.1-pl3/';
$cfg['Servers
Howdy all,
I keep getting this error when I try to issue:
mysql mysql -u root -p
the same thing happens when I substitute any other database name, not just
mysql. I have another,nearly identical machine from which I copied the
contents of /var/lib/mysql/mysql/ . The permissions all appear to
Hello.
Using the general-log you could find if something
changes the grant tables. See:
http://dev.mysql.com/doc/mysql/en/query-log.html
Also I strongly recommend you to upgrade to the latest
release, if you don't use it already.
so whats the final solution to my problem ? :(
them,after some hour later
all the scripts show me that error : Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES)
then im trying to do : GRANT ALL PRIVILEGES ON somethign.* TO
[EMAIL PROTECTED] IDENTIFIED BY password; and then each database that
i re-give
mambo etc).
the problem is that they only work as I install them,after some hour later
all the scripts show me that error : Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES)
then im trying to do : GRANT ALL PRIVILEGES ON somethign.* TO
[EMAIL PROTECTED] IDENTIFIED
Hello.
Execute FLUSH PRIVILEGES after granting.
See:
http://dev.mysql.com/doc/mysql/en/flush.html
http://dev.mysql.com/doc/mysql/en/privilege-changes.html
http://dev.mysql.com/doc/mysql/en/access-denied.html
http://dev.mysql.com/doc/mysql/en/user-resources.html
Connect to the
is that they only work as I install them,after some hour later
all the scripts show me that error : Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES)
then im trying to do : GRANT ALL PRIVILEGES ON somethign.* TO
[EMAIL PROTECTED] IDENTIFIED BY password; and then each database
I have installed in a single user called metal-host
more than 10 databases all with different names
and in different php scripts (phpbb phpnuke mambo etc).
the problem is that they only work as I install them,after some hour later
all the scripts show me that error : Access denied for user
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
Hello.
I successufully connected to MySQL server using your parameters
in odbc.ini and odbcinst.ini files from php.
[unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user:
'[EMAIL PROTECTED]' (Using password: NO)
You have specified the user and the password in the ODBC
][ODBC 3.51 Driver]Access denied for user:
'[EMAIL PROTECTED]' (Using password: NO)
The user apacheusr is the username that the Apache webserver is running
under. I've tried adding this user to the MySQL user table but the error
still shows.
However, if I add the Username and Password along
Hi All,
I am consistently getting;
Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
I am connecting through php with the same script I use all the time, I have
checked it and dbl checked it for problems.
I can connect to mysql in a prompt and I have added new users with all
hi
you are not passing a password to mysql - check your code to see if this is
correct.
Peter
-Original Message-
From: Christian Biggins [mailto:[EMAIL PROTECTED]
Sent: 26 January 2005 12:27
To: mysql@lists.mysql.com
Subject: Access denied for user - I cant work this out
Hi All
: Peter Lovatt [mailto:[EMAIL PROTECTED]
Sent: Thursday, 27 January 2005 12:27 AM
To: Christian Biggins; mysql@lists.mysql.com
Subject: RE: Access denied for user - I cant work this out
hi
you are not passing a password to mysql - check your code to see if this is
correct.
Peter
-Original
Subject: RE: Access denied for user - I cant work this out
Hi Peter,
There is a password being suppled - see code (btw, its local testing only,
hence the root user)
//Database Settings
$db_host = 'localhost'; //database hostname $db_name =
'powerpla_powerplay'; //database name $db_user
');
}
}
HTH
Peter
-Original Message-
From: Christian Biggins [mailto:[EMAIL PROTECTED]
Sent: 26 January 2005 13:30
To: 'Peter Lovatt'; mysql@lists.mysql.com
Subject: RE: Access denied for user - I cant work this out
Hi Peter,
There is a password being suppled - see code (btw
I've put together a shell script that is simply -
/usr/bin/mysqldump -u user -ppassword db dbBackup.sql
When I run this script I get the error 1045: Access denied for user '
[EMAIL PROTECTED]' (Using password: YES) when trying to connect
When I log into mysql - user#mysql -u user -p password
To: mysql@lists.mysql.com
Subject: mysqldump access denied error
I've put together a shell script that is simply -
/usr/bin/mysqldump -u user -ppassword db dbBackup.sql
When I run this script I get the error 1045: Access denied for user '
[EMAIL PROTECTED]' (Using password: YES) when trying
/2005 01:13 PM
To
Tait Sanders [EMAIL PROTECTED], mysql@lists.mysql.com
cc
Subject
RE: mysqldump access denied error
Hi Tait,
Have you tried show databases to make sure that user can actually use
that database?
mysqlshow databases;
That will tell you if that user has access as it won't show
From: Tait Sanders [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 18 January 2005 1:47 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: RE: mysqldump access denied error
yes the user can see the databases with 'show databases;'
I was thinking that there might
- Adelaide) [EMAIL PROTECTED]
18/01/2005 01:23 PM
To
Tait Sanders [EMAIL PROTECTED]
cc
mysql@lists.mysql.com
Subject
RE: mysqldump access denied error
Check that the user has FILE privileges, given that a SELECT ... INTO
OUTFILE sounds awfully like a mysqldump :-
The FILE privilege gives you
Sanders [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 18 January 2005 1:36 PM
To: mysql@lists.mysql.com
Subject: mysqldump access denied error
I've put together a shell script that is simply -
/usr/bin/mysqldump -u user -ppassword db dbBackup.sql
When I run this script I get the error 1045: Access
by 'password';
ERROR 1044 (42000): Access denied for user 'root'
What could be the reason???
I though the mysql root user was analogous to the unix counterpart
Thanks a lot in advance for your help.
Regards,
Ed
--
For technical support contracts, goto https
Hi,
As the root user I created a DB a populated with tables... but when I want
to create a user to handle that DB i get this error message:
mysql grant all on db.* to [EMAIL PROTECTED] identified by 'password';
ERROR 1044 (42000): Access denied for user 'root'
What could be the reason???
I
!!! [mailto:[EMAIL PROTECTED] On
Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, December 15, 2004 11:34 AM
To: [EMAIL PROTECTED]
Subject: ERROR 1044 (42000): Access denied for user 'root'
Hi,
As the root user I created a DB a populated with tables... but when I
want
to create a user to handle
Since I see this question every single day hereI will post this link.
http://dev.mysql.com/doc/mysql/en/Access_denied.html
It is a decent page on the MySQL site that gives you reasons why you get
Access Denied.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Subj: Re: Access denied for root user
MueR wrote:
Hello,
I've recently had my HD crash, and have reinstalled everything.
Everything seems to work fine, apart from one thing. My MySQL server
has decided to randomly set a root password
MueR wrote:
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Subj: Re: Access denied for root user
MueR wrote:
Hello,
I've recently had my HD crash, and have reinstalled everything.
Everything seems to work fine, apart from one thing. My MySQL server
has decided to randomly set a root password
with the --skip-grant-tables command, I've tried
to update
the user table manually.
Everything seems to work out just fine, until the moment I attempt to
login
using the root account. It will give me the error # 1045 (access denied
for
user [EMAIL PROTECTED]).
Nothing seems to work. Has anyone ever
(access denied for user [EMAIL PROTECTED]).
That's not the full error message, and you've tried a lot of things, so it's
hard to diagnose the problem.
Nothing seems to work. Has anyone ever had this problem? Do you know
a solution to it? I am using MySQL v 3.23.49, on a Debian system.
I'd suggest
/data/test, I did a load data
command exactly as I have done many times before and got
ERROR 1045 Access denied for user: '@localhost' (Using password: NO)
I was able to create the table and successfully issue the commands SHOW
TABLES and DESCRIBE TABLENAME As below mysql is installed
command exactly as I have done many times before and got
ERROR 1045 Access denied for user: '@localhost' (Using password: NO)
I was able to create the table and successfully issue the commands SHOW
TABLES and DESCRIBE TABLENAME As below mysql is installed on a pc running
Windows 98.
Ken
to connect to any hosts due to exception:
java.security.AccessControlException: access denied (java.net.SocketPermission
155.47.139.247:3306 connect,resolve)
SQLState: 08S01
VendorError: 0
When I used localhost I received this error:
SQLException: Unable to connect to any hosts due to exception
:
SQLException: Unable to connect to any hosts due to exception:
java.security.AccessControlException: access denied (java.net.SocketPermission
127.0.0.1:3306 connect,resolve)
SQLState: 08S01
VendorError: 0
Does anyone know what this means, or how to fix this?
Thanks in advance
PROTECTED]
Sent: Wednesday, August 04, 2004 5:57 PM
To: [EMAIL PROTECTED]
Subject: SQLException: Unable to connect to any hosts due to exception:
java.security.AccessControlException: access denied
(java.net.SocketPermission 127.0.0.1:3306 connect,resolve)
I am trying to connect to a database
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.
--
Hi -
I am new to MySQL - I just recently re-installed MySQL by rpm and when ever I try to
issue a command from the shell prompt, such as mysqladmin or mysqlshow, I would get
the error of 'Access denied for user: '[EMAIL PROTECTED]' mailto:'[EMAIL PROTECTED]'
(Using password: NO)'.
Could
get the error of
'Access denied for user: '[EMAIL PROTECTED]' mailto:'[EMAIL PROTECTED]' (Using
password: NO)'.
Could someone please tell me what I need to set or did not set.
Thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
(Mission Systems)
Cc: [EMAIL PROTECTED]
Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
Re-installing does not get rid of your old passwords.
You need to use the -p option.
Nguyen, Long P (Mission Systems) wrote:
Hi -
I am new to MySQL - I just recently re
On Thursday 01 July 2004 09:08 am, Nguyen, Long P (Mission Systems) wrote:
shouldn't I be able to issue commands at the shell it goes and does it
thing and give back output? or does this mean I have a passwd already set
and it's secured?
:
# 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
On Friday 11 June 2004 06:59 pm, Robert Paulsen wrote:
I must be missing something about create temporary table. Here are two
sql commands. The first works the second fails:
CREATE TABLE mytable (id int(10) NOT NULL auto_increment, data
varchar(255), PRIMARY KEY (id) ); CREATE
I must be missing something about create temporary table. Here are two sql
commands. The first works the second fails:
CREATE TABLE mytable (id int(10) NOT NULL auto_increment, data
varchar(255), PRIMARY KEY (id) );
CREATE TEMPORARY TABLE mytable2 (id int(10) NOT NULL
CREATE DATABASE menagerie;
ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
I have read the documentation again and again, it show I can create a host file, but
ite does not say what kind file it is and where I should put it. How can I fix it?
Thank you for your help
101 - 200 of 580 matches
Mail list logo