Re: mysql Access denied error

Edward , use following way mysql -uroot -p -h{host ip } else give grant privileges to localhost On Mon, May 5, 2014 at 7:47 AM, EdwardKing wrote: > I use mysql to create a database and grant rights to a user > hadooptest,then I use hadooptest to login mysql and use the database,but it > fa

Re: mysql Access denied error

On 2014-05-04 9:17 PM, EdwardKing wrote: I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. The command sequence ... mysql> create data

Re: mysql Access denied error

Am 05.05.2014 15:26, schrieb Johan De Meersman: > - Original Message - >> From: "Reindl Harald" >> >> i know that, but it does not change the fact that here > > Either you didn't know that but have trouble admitting it; or you did but > conciously chose to be rude and condescending in

Re: mysql Access denied error

- Original Message - > From: "Reindl Harald" > > i know that, but it does not change the fact that here Either you didn't know that but have trouble admitting it; or you did but conciously chose to be rude and condescending instead of helpful. Your choice. In the second scenario, I

Re: mysql Access denied error

Am 05.05.2014 11:12, schrieb Jigal van Hemert: > On 5-5-2014 10:57, Reindl Harald wrote: >> >> >> Am 05.05.2014 10:19, schrieb Manuel Arostegui: >>> 2014-05-05 10:00 GMT+02:00 Reindl Harald >> >: >>> >>> Am 05.05.2014 08:34, schrieb Manuel Arostegui: >>> >

Re: mysql Access denied error

Hi, On 5-5-2014 10:57, Reindl Harald wrote: Am 05.05.2014 10:19, schrieb Manuel Arostegui: 2014-05-05 10:00 GMT+02:00 Reindl Harald mailto:h.rei...@thelounge.net>>: Am 05.05.2014 08:34, schrieb Manuel Arostegui: > "%" doesn't match localhost so if you don't specify it you will be

Re: mysql Access denied error

2014-05-05 10:57 GMT+02:00 Reindl Harald : > > > Am 05.05.2014 10:19, schrieb Manuel Arostegui: > > 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net>>: > > > > Am 05.05.2014 08:34, schrieb Manuel Arostegui: > > > "%" doesn't match localhost so if you don't specify it you wi

Re: mysql Access denied error

Am 05.05.2014 10:19, schrieb Manuel Arostegui: > 2014-05-05 10:00 GMT+02:00 Reindl Harald >: > > Am 05.05.2014 08:34, schrieb Manuel Arostegui: > > "%" doesn't match localhost so if you don't specify it you will be > > attempting to connect via Unix So

Re: mysql Access denied error

2014-05-05 10:00 GMT+02:00 Reindl Harald : > > > Am 05.05.2014 08:34, schrieb Manuel Arostegui: > > "%" doesn't match localhost so if you don't specify it you will be > > attempting to connect via Unix Socket. > > If you don't want to specify -hlocalhost all the time, just do the grant > > with "@

Re: mysql Access denied error

Am 05.05.2014 08:34, schrieb Manuel Arostegui: > "%" doesn't match localhost so if you don't specify it you will be > attempting to connect via Unix Socket. > If you don't want to specify -hlocalhost all the time, just do the grant > with "@localhost" instead of "@%" nonsense % matches *any hos

Re: mysql Access denied error

2014-05-05 4:17 GMT+02:00 EdwardKing : > I use mysql to create a database and grant rights to a user > hadooptest,then I use hadooptest to login mysql and use the database,but it > failed. Why raise error after I grant rights? How to solve it? Thanks. > > My operation is follows: > > [hadoop@maste

mysql Access denied error

I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. My operation is follows: [hadoop@master ~]$ mysql -h localhost -u root -p Enter password

Re: "access denied" error

nks, Jesse - Original Message - From: Jim Lyons To: Jesse Cc: MySQL List Sent: Friday, October 10, 2008 8:28 AM Subject: Re: "access denied" error What is the PHP connect string? Are you connecting to the database you have access to? are you connecting as t

Re: "access denied" error

What is the PHP connect string? Are you connecting to the database you have access to? are you connecting as the same user (myuser)? Do other php applications work, so you know it's not a php-mysql issue? On Fri, Oct 10, 2008 at 6:59 AM, Jesse <[EMAIL PROTECTED]> wrote: > I have a PHP applicati

"access denied" error

I have a PHP application that I inherited. I have it running on a Ubuntu 8.04 virtual machine. I have set up a user to access the MySQL database, and from the command prompt, I can access it just fine. For instance, from the Ubuntu prompt, if I type MySQL -umyuser -p, it asks me for the passw

SOLVED:RE: mysqldump access denied error

ait 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

RE: mysqldump access denied error

ediately. "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> 18/01/2005 01:23 PM To "Tait Sanders" <[EMAIL PROTECTED]> cc Subject RE: mysqldump access denied error Check that the user has FILE privileges, given that a SELECT ... INTO OUTFILE sou

RE: mysqldump access denied error

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

RE: mysqldump access denied error

; <[EMAIL PROTECTED]> 18/01/2005 01:13 PM To "Tait Sanders" <[EMAIL PROTECTED]>, cc Subject RE: mysqldump access denied error Hi Tait, Have you tried show databases to make sure that user can actually use that database? mysql>show databases; That will tell you

RE: mysqldump access denied error

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 denied for user ' [EMAIL PROTECTED]' (Usin

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 to connect" When I log into mysql - user#mysql -u user -p passwo

Re: Access denied error

"Shane Korosec" <[EMAIL PROTECTED]> wrote: > I have recently installed MySQL my mac running OS X 10.3 and can connect to > MySQL using the command: > /Library/MySQL/bin/mysql > However, once connected, I have tried to create a database and received the > error message: > ERROR 1044: Access denie

RE: Access denied error

You need to connect as a privileged user. You should delete the anonymous account for security reasons. -Original Message- From: Shane Korosec [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 1:56 AM To: [EMAIL PROTECTED] Subject: Access denied error I have recently installed

Access denied error

I have recently installed MySQL my mac running OS X 10.3 and can connect to MySQL using the command: /Library/MySQL/bin/mysql However, once connected, I have tried to create a database and received the error message: ERROR 1044: Access denied for user: '@localhost' to database 'new_database' I

Re: Access denied error

Jeff Roberts <[EMAIL PROTECTED]> wrote: > I have a fresh install of mysql 4.0.11 on a linux box. When I try to > open mysql as a [EMAIL PROTECTED], I get the following error: > >>mysql -u [EMAIL PROTECTED] -p db_name >Enter password: >ERROR 1045: Access denied for user: '[EMAIL PROTECT

Access denied error

I have a fresh install of mysql 4.0.11 on a linux box. When I try to open mysql as a [EMAIL PROTECTED], I get the following error: >mysql -u [EMAIL PROTECTED] -p db_name Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]@localhost' (Using password: YES) However

re: mysqladmin access denied error

On Friday 20 December 2002 15:31, Imran Khan wrote: > I'm using solaris 8 with mysql v 3.23.54. > > I want to enable a solaris user - 'user1', to use the mysqlimport command > without using a password. > > I've run, as root, the following sql command: > mysql>grant all on db1.* to user1@localhost

re: mysqladmin access denied error

On Friday 20 December 2002 15:31, Imran Khan wrote: > I'm using solaris 8 with mysql v 3.23.54. > > I want to enable a solaris user - 'user1', to use the mysqlimport command > without using a password. > > I've run, as root, the following sql command: > mysql>grant all on db1.* to user1@localhost

re: mysqladmin access denied error

On Friday 20 December 2002 15:31, Imran Khan wrote: > I'm using solaris 8 with mysql v 3.23.54. > > I want to enable a solaris user - 'user1', to use the mysqlimport command > without using a password. > > I've run, as root, the following sql command: > mysql>grant all on db1.* to user1@localhost

re: mysqladmin access denied error

On Friday 20 December 2002 15:31, Imran Khan wrote: > I'm using solaris 8 with mysql v 3.23.54. > > I want to enable a solaris user - 'user1', to use the mysqlimport command > without using a password. > > I've run, as root, the following sql command: > mysql>grant all on db1.* to user1@localhost

re: mysqladmin access denied error

On Friday 20 December 2002 15:31, Imran Khan wrote: > I'm using solaris 8 with mysql v 3.23.54. > > I want to enable a solaris user - 'user1', to use the mysqlimport command > without using a password. > > I've run, as root, the following sql command: > mysql>grant all on db1.* to user1@localhost

mysqladmin access denied error

Hi, I'm using solaris 8 with mysql v 3.23.54. I want to enable a solaris user - 'user1', to use the mysqlimport command without using a password. I've run, as root, the following sql command: mysql>grant all on db1.* to user1@localhost -this appears to work fine. However as user1 in the solari

Re: Access denied error

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_r

Re: Access denied error

VINOD, Saturday, July 06, 2002, 6:49:50 AM, you wrote: V> I own a domain with MySQL support. I have created a database V> \"lnet_cal\" on the web and also table \"yarntype\", using PHP Myad- V> min on the webspace and also granted all access privileges to V> user \"lnet_root\" to the da

Access denied error

using PHP Myadmin provided by the web provider, the text file was inserted to the table with out any problem. When the same text file is inserted through PHP scripts, I have got the access denied error. The same script is working fine when I executed it in a local machine. Please suggest me o

Access denied error

ext file using PHP Myadmin provided by the web provider, the text file was inserted to the table with out any problem. When the same text file is inserted through PHP scripts, I have got the access denied error. The same script is working fine when I executed it in a local machine. Please sugg

Access denied error

using PHP Myadmin provided by the web provider, the text file was inserted to the table with out any problem. When the same text file is inserted through PHP scripts, I have got the access denied error. The same script is working fine when I executed it in a local machine. Please suggest me o

RE: Access denied error

Hi, > i am trying to import or export using MYSQL driver. that time it > gives following error; > "Access Denied For User '[EMAIL PROTECTED]' (Using password:YES) did you give all the privileges manually through editing the grant tables, or by the GRANT command (the right command should be some

Access denied error

hi, I have installed mysql 3.22.29 in our RedHat 6.0 server and i give all privileges to user, and i have installed myodbc in my window 98 machine. i am trying to import or export using MYSQL driver. that time it gives following error; "Access Denied For User '[EMAIL PROTECTED]'

Re: MyODBC Access Denied Error

In message <1D9A6579106BD411BA9700A0C9A50975191A97@AFTERBURNER>, Randy Davis <[EMAIL PROTECTED]> writes >I was wondering if anybody would be able to help me with this. I've got a >MySQL database set up on my Linux server. I want to be able to access it >remotely, but all we get when we try to a

MyODBC Access Denied Error

I was wondering if anybody would be able to help me with this. I've got a MySQL database set up on my Linux server. I want to be able to access it remotely, but all we get when we try to access is the following message: ODBC - call failed [MyODBC] Access denied for user: 'user@hostname' (Using