Re: Access Denied When Trying to Create Database

2007-06-11 Thread Gerald L. Clark
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

Re: Access Denied When Trying to Create Database

2007-06-11 Thread untz
'' 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

Re: Access Denied When Trying to Create Database

2007-06-11 Thread Rolando Edwards
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

Re: Access Denied When Trying to Create Database

2007-06-11 Thread untz
' 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

Access Denied When Trying to Create Database

2007-06-10 Thread untz
: 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

Re: Access Denied When Trying to Create Database

2007-06-10 Thread Baron Schwartz
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

Re: Access Denied When Trying to Create Database

2007-06-10 Thread untz
'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

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

2007-05-09 Thread Thibaud Hulin
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

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

2007-05-09 Thread Cassj
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

mysql_upgrade not running mysql_check: Access denied for user 'root'@'localhost'

2007-04-26 Thread Janek Bogucki
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

ERROR 1045 (28000): Access denied for user 'root'@'localhost'

2007-02-20 Thread thomas Armstrong
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

ERROR 1045 (28000): Access denied for user 'root'@'localhost'

2007-02-20 Thread thomas Armstrong
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

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost'

2007-02-20 Thread thomas Armstrong
. 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

Access Denied in Query Browser

2006-07-07 Thread jonas
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

Error 1045 - Access denied

2006-06-16 Thread Miles Thompson
) --- 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

Re: Error 1045 - Access denied

2006-06-16 Thread Dan Buettner
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

Re: Error 1045 - Access denied

2006-06-16 Thread Miles Thompson
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

Access denied

2006-06-09 Thread Kaushal Shriyan
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

Re: Access denied

2006-06-09 Thread Dilipkumar
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

Re: Access denied

2006-06-09 Thread Kaushal Shriyan
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

Re: Access denied

2006-06-09 Thread Barry
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

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

2006-06-08 Thread Aron Levy
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

ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

2006-06-07 Thread Aron Levy
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

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

2006-06-07 Thread James Barros
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

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

2006-06-07 Thread Aron Levy
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

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

2006-06-07 Thread Daniel da Veiga
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

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

2006-06-07 Thread James Barros
] ~]# 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

1045 access denied after granting all privs

2006-02-08 Thread John Doneker
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

Re: 1045 access denied after granting all privs

2006-02-08 Thread SGreen
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

Re: 1045 access denied after granting all privs

2006-02-08 Thread Julian C. Dunn
. 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

Re: 1045 access denied after granting all privs

2006-02-08 Thread dan+mysql-general-discussion-list
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

Access denied after upgrade to 5.0

2006-01-28 Thread M
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

Re: Access denied after upgrade to 5.0

2006-01-28 Thread Gleb Paharenko
-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

Re: New install--access denied

2006-01-16 Thread Gleb Paharenko
' 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

New install--access denied

2006-01-11 Thread Thom Hehl
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

Re: Access denied/password change

2005-06-06 Thread Seena Blace
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

Re: Access denied/password change

2005-06-06 Thread mfatene
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

Re: Access denied

2005-06-05 Thread Gleb Paharenko
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

Re: Access denied

2005-06-05 Thread Anoop kumar V
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

Access denied

2005-06-03 Thread Seena Blace
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

Re: 'ERROR 1045 (28000): Access denied' when trying to LOAD DATA INFILE.

2005-05-29 Thread Gleb Paharenko
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

'ERROR 1045 (28000): Access denied' when trying to LOAD DATA INFILE.

2005-05-28 Thread Jeroen Van Goey
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

Re: Access denied for user: 'apache@localhost' (Using password: NO)

2005-04-19 Thread Jorge Cambra Aused
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

Re: Access denied for user: 'apache@localhost' (Using password: NO)

2005-04-19 Thread Gleb Paharenko
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

Access denied for user: 'apache@localhost' (Using password: NO)

2005-04-18 Thread Jorge Cambra Aused
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

Re: Access denied for user: 'apache@localhost' (Using password: NO)

2005-04-18 Thread Gleb Paharenko
(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

Fw: Access denied-phpMyAdmin

2005-04-17 Thread Alvaro Cobo
, 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

Access denied-phpMyAdmin

2005-04-16 Thread Mark Sargent
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

ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

2005-04-04 Thread Samuel Flores
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

Re: Access Denied

2005-03-15 Thread Gleb Paharenko
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 ? :(

Re: Access Denied

2005-03-10 Thread Gleb Paharenko
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

Re: Access Denied

2005-03-09 Thread Michael Stassen
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

Re: Access Denied

2005-03-08 Thread Gleb Paharenko
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

Re: Access Denied

2005-03-07 Thread Gleb Paharenko
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

Access Denied

2005-03-06 Thread Metal Host Contact
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

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

2005-03-04 Thread Gleb Paharenko
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

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

2005-03-03 Thread Deniss Hennesy
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

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

2005-03-03 Thread Deniss Hennesy
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

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

2005-03-03 Thread sam wun
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

Re: Access Denied For User

2005-02-28 Thread Gleb Paharenko
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

Access Denied For User

2005-02-23 Thread Dan Wareham
][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

Access denied for user - I cant work this out

2005-01-26 Thread Christian Biggins
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

RE: Access denied for user - I cant work this out

2005-01-26 Thread Peter Lovatt
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

RE: Access denied for user - I cant work this out

2005-01-26 Thread Christian Biggins
: 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

RE: Access denied for user - I cant work this out

2005-01-26 Thread Tom Crimmins
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

RE: Access denied for user - I cant work this out

2005-01-26 Thread Peter Lovatt
'); } } 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

mysqldump access denied error

2005-01-17 Thread Tait Sanders
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

RE: mysqldump access denied error

2005-01-17 Thread Logan, David (SST - Adelaide)
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

RE: mysqldump access denied error

2005-01-17 Thread Tait Sanders
/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

RE: mysqldump access denied error

2005-01-17 Thread Logan, David (SST - Adelaide)
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

RE: mysqldump access denied error

2005-01-17 Thread Tait Sanders
- 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

SOLVED:RE: mysqldump access denied error

2005-01-17 Thread Tait Sanders
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

Re: ERROR 1044 (42000): Access denied for user 'root'

2004-12-16 Thread Gleb Paharenko
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

ERROR 1044 (42000): Access denied for user 'root'

2004-12-15 Thread estoy
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

RE: ERROR 1044 (42000): Access denied for user 'root'

2004-12-15 Thread Dave Juntgen
!!! [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

Access Denied

2004-10-14 Thread Michael J. Pawlowsky
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

RE: Access denied for root user

2004-08-29 Thread MueR
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

Re: Access denied for root user

2004-08-29 Thread Michael Stassen
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

Access denied for root user

2004-08-28 Thread MueR
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

Re: Access denied for root user

2004-08-28 Thread Michael Stassen
(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

Re: Access Denied

2004-08-10 Thread Egor Egorov
/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

Access Denied

2004-08-09 Thread kc68
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

RE: 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)

2004-08-05 Thread Nathan Pierce
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)

2004-08-04 Thread Nathan Pierce
: 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

RE: 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)

2004-08-04 Thread Sergei Skarupo
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

ERROR 1045: Access denied for user: 'mysqladmin@localhost' (Using password: YES)

2004-07-19 Thread Laurent
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]

RE: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)

2004-07-19 Thread Victor Pendleton
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

Re: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)

2004-07-19 Thread Laurent
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

Re: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)

2004-07-19 Thread Thomas Spahni
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

RE: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)

2004-07-19 Thread Victor Pendleton
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

Re: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (Using password: YES)

2004-07-19 Thread Egor Egorov
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. --

Access denied for user: 'root@localhost' (Using password: NO)

2004-07-01 Thread Nguyen, Long P (Mission Systems)
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

Re: Access denied for user: 'root@localhost' (Using password: NO)

2004-07-01 Thread gerald_clark
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

RE: Access denied for user: 'root@localhost' (Using password: NO)

2004-07-01 Thread Nguyen, Long P (Mission Systems)
(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

Re: Access denied for user: 'root@localhost' (Using password: NO)

2004-07-01 Thread James E Hicks III
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?

Re: ERROR 1045: Access denied for user: 'foo@host' (Using password: YES)

2004-06-19 Thread Egor Egorov
: # 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: 'foo@host' (Using password: YES)

2004-06-18 Thread Marc Tardif
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

Re: [SOLVED?] Access Denied for CREATE TEMPORARY TABLE

2004-06-12 Thread Robert Paulsen
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

Access Denied for CREATE TEMPORARY TABLE

2004-06-11 Thread Robert Paulsen
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

ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'

2004-06-08 Thread c s
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

<    1   2   3   4   5   6   >