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 zhan...@neusoft.com 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
2014-05-05 4:17 GMT+02:00 EdwardKing zhan...@neusoft.com:
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:
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 host*
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 will be
attempting to connect via Unix Socket.
If you don't want to specify -hlocalhost all the time, just do the grant
Am 05.05.2014 10:19, schrieb Manuel Arostegui:
2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net
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
attempting to
2014-05-05 10:57 GMT+02:00 Reindl Harald h.rei...@thelounge.net:
Am 05.05.2014 10:19, schrieb Manuel Arostegui:
2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.netmailto:
h.rei...@thelounge.net:
Am 05.05.2014 08:34, schrieb Manuel Arostegui:
% doesn't match
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 h.rei...@thelounge.net
mailto:h.rei...@thelounge.net:
Am 05.05.2014 08:34, schrieb Manuel Arostegui:
% doesn't match localhost so if you don't
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 h.rei...@thelounge.net
mailto:h.rei...@thelounge.net:
Am 05.05.2014 08:34, schrieb Manuel Arostegui:
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
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
Am 05.05.2014 15:26, schrieb Johan De Meersman:
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
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
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
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
- 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 the same user (myuser)? Do
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
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 application
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
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
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 denied for
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
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
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:
mysqlgrant all on db1.* to user1@localhost
-this
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:
mysqlgrant all on db1.* to user1@localhost
-this
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:
mysqlgrant all on db1.* to user1@localhost
-this
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:
mysqlgrant all on db1.* to user1@localhost
-this
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:
mysqlgrant all on db1.* to user1@localhost
-this appears to work fine.
However as user1 in the
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:
mysqlgrant all on db1.* to user1@localhost
-this
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
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 database.
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 on how to overcome the problem.
The script which I have
, 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 on how to overcome the problem.
The script which I
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 on how to overcome the problem.
The script which I have
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
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 access
38 matches
Mail list logo