Am 29.05.2014 20:22, schrieb Érico:
I have ran the following to test a fix for an app issue :
delete from mysql.user where user='';
2lines got effected
after this I can´t connect through command line anymore :
./mysqladmin -u root password pwd
I get access denied for user
Did you tried this..
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
*thanks,*
*-- *Kishore Kumar Vaishnav
On Thu, May 29, 2014 at 11:22 AM, Érico erico...@gmail.com wrote:
I have ran the following to test a fix for an app issue :
delete from mysql.user where user='';
Hi
thanks but it is not working either
I wonder if the 2 rows I removed (with empty users for localhost and my
computer names) were responsilbe for allowing the autentication ?
how this table works ?
what mysql checks on it ? the pwd column ? if it is filled ?
what if I have 2 records for
running this :
./mysqladmin -u root -p
at this momento it thorws me to mysqladmin man page
2014-05-29 15:35 GMT-03:00 Reindl Harald h.rei...@thelounge.net:
Am 29.05.2014 20:22, schrieb Érico:
I have ran the following to test a fix for an app issue :
delete from mysql.user where
well, i am mysql administrator over 10 years now
and never needed the mysqladmin command because
the mysql command line client offers anything i
ever needed
mysql -u root -p
[harry@srv-rhsoft:~]$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your
Hello Érico
On 5/29/2014 2:22 PM, Érico wrote:
I have ran the following to test a fix for an app issue :
delete from mysql.user where user='';
2lines got effected
after this I can´t connect through command line anymore :
./mysqladmin -u root password pwd
I get access denied for user
I am really sorry about this one ..
the connection is ok ...
I had not checked that I was using mysqladmin instead of mysql
now please how can I check what is wrong with my application ( My SQL Admin
)
at its login page it asks for user / pwd / server and db
using both localhost and 127.0.01
Hello Érico,
On 5/29/2014 3:51 PM, Érico wrote:
I am really sorry about this one ..
the connection is ok ...
I had not checked that I was using mysqladmin instead of mysql
now please how can I check what is wrong with my application ( My SQL Admin
)
at its login page it asks for user / pwd
ok
I have tried these :
ifconfig -a
lo0: flags=8049UP,LOOPBACK,RUNNING,MULTICAST mtu 16384
inet6 ::1 prefixlen 128
inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1
inet 127.0.0.1 netmask 0xff00
gif0: flags=8010POINTOPOINT,MULTICAST mtu 1280
stf0: flags=0 mtu 1280
fw0:
Hi
| | ericomtxmacbookpro.local |
*E85DC00A0137C6171923BE35EDD809573FB3AB4F |
mysql DELETE FROM mysql.user WHERE user='';
mysql FLUSH PRIVILEGES;
maybe helps?
Cheers
--
Claudio
yes it is ...
also , the eclipse is also local ...
in both ... mysql-admin php application , plus inside eclispe plugin ...
same behavior in both
2014/1/13 Reindl Harald h.rei...@thelounge.net
i doubt that the webserver is running on the same
machine as your mysql command shell
Am
Am 13.01.2014 18:28, schrieb Érico:
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 5.6.15 MySQL Community Server (GPL)
but in the browser I get the
From that error I would suspect you are trying to access to a database
where has not external access. And yeah, try by doing
$ mysql -u root -p database -h localhost -P 3306
change localhost by 127.0.0.1 in order to test if both cases work, and
see which of them (localhost/127.0.0.1) is defined
using both urls I get the same error :
http://localhost/mysql/index.php
http://127.0.0.1/mysql/index.php
in 127.0.0.1... after I submit the index.php ... it redirects to localhost
too ..
2014/1/13 Reindl Harald h.rei...@thelounge.net
Am 13.01.2014 18:28, schrieb Érico:
using localhost the coonection works ...
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h
localhost -P 3306
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL
I presume your index.php file uses 127.0.0.1. After login to MySQL try this:
$ grant all privileges to *.* 'root'@'127.0.0.1' identified by yourpassword;
Of course this could not be the best solution, it's just to skip it,
you must look at the query/connection on your php file.
On 13 January
I forgot this. Do it too.
On 13 January 2014 13:01, Erick Ocrospoma zipper1...@gmail.com wrote:
I presume your index.php file uses 127.0.0.1. After login to MySQL try this:
$ grant all privileges to *.* 'root'@'127.0.0.1' identified by
yourpassword;
$ flush privileges;
Of course this could
the granting is not affecting the tables:
mysql grant all privileges on *.* to root@localhost identified by 'pwd';
Query OK, 0 rows affected (0.00 sec)
mysql FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
...
and if I try the granting in 127.0.0.1 :
mysql grant all privileges to *.*
On 13 January 2014 13:25, Érico erico...@gmail.com wrote:
the granting is not affecting the tables:
mysql grant all privileges on *.* to root@localhost identified by 'pwd';
Query OK, 0 rows affected (0.00 sec)
mysql FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
...
and if I try
Hi
didn't work
look ... isn't this something related to this :
are you using localhost or 127.0.0.1 in the web-application
root@localhost != root@127.0.0.1 = different users
localhost: Unix-Socket
127.0.0.1: TCP
...
since I am not able to stabilsh a connection even with using eclipse ...
my
Hello Érico,
On 1/13/2014 1:49 PM, Érico wrote:
Hi
didn't work
look ... isn't this something related to this :
are you using localhost or 127.0.0.1 in the web-application
root@localhost != root@127.0.0.1 = different users
localhost: Unix-Socket
127.0.0.1: TCP
...
since I am not able to
Hi
no connections outside command line are being accepted . I have connected
through command line , but not using eclipse for example ... it gets the
same error from the web app
my apache and pages are in the same computer that mysql
I am not getting password issues.. otherwise I would not
WTF - we are talking about *database connections* and *not* http-URL's
the webserver is only the *messenger*
Am 13.01.2014 18:54, schrieb Érico:
using both urls I get the same error :
http://localhost/mysql/index.php
http://127.0.0.1/mysql/index.php
in 127.0.0.1... after I submit the
*your application* is connecting to mysql
*your application* is using a hostname
*your application* *may* use 127.0.0.1
*your application* should use localhost to *connect to the databse*
*your application* can only use TCP *if there is* a *mysql user* with *that
host*
Hello Reindl,
On 1/13/2014 3:01 PM, Reindl Harald wrote:
*your application* is connecting to mysql
*your application* is using a hostname
*your application* *may* use 127.0.0.1
*your application* should use localhost to *connect to the databse*
*your application* can only use TCP *if there is*
provide the output of the below query.
Select user, host, password from mysql.user;
Thanks
Vikas Shukla
Mail Sent from my Windows Phone From: Reindl Harald
Sent: =E2=80=8E14-=E2=80=8E01-=E2=80=8E2014 01:38
To: mysql@lists.mysql.com
Subject: Re: Access denied for user 'root'@'localhost' (using
Am 13.01.2014 21:47, schrieb shawn l.green:
Hello Reindl,
We are not saying he is using HTTP commands to log into his database
we excludes obviously the OP or his overall understanding :-)
Am 13.01.2014 18:54, schrieb Érico:
using both urls I get the same error :
You mysql.user table might be corrupted.
If you have access to it as a root user, try check table mysql.user, and
repair table mysql.user if table corruption was detected.
Alternatively, shut down mysql server, cd /var/lib/mysql/mysql (to your
$datadir/mysql directory) and run
mysqlcheck -r
Hi,
¶¼ÊÇÖйúÈ˾Í˵ÖÐÎÄ°É^_^
Nice to meet you. But I think that this newsgroup is for the people who come
from all of the world. So post topics in English is better for anyone who is
also interested about this topic, right?
Ã÷Ìì»á¸üºÃ
I like this sentence.
On 2010年09月24日 16:11, Ma Xiaoming wrote:
Dear all,
I have installed the MySQL version 5.1.50 with complete installation. After
the installation process is finished and the configuration is done, when I
run 'mysqladmin' with option 'version' in prompt, I got the following error
message:
Hi,
As the console print,do you enter the password for user ODBC correctly?
How to correctly use this console application, that is how to pass password
when calling this console application? Thanks.
ODBCÓû§ÃÜÂë²»¶Ô£¬ËµµÄºÜÃ÷ÏÔ.
On 9/24/2010 4:11 AM, Ma Xiaoming wrote:
Dear all,
I have installed the MySQL version 5.1.50 with complete installation. After
the installation process is finished and the configuration is done, when I
run 'mysqladmin' with option 'version' in prompt, I got the following error
message:
Hi Shawn,
You forgot to use -- before the option version. Try this instead
mysqladmin --version
Let us know your results.
Oh yes, it works. When I typed the right command: mysqladmin --version
I got the following result: mysqladmin Ver 8.42 Distrib 5.1.50, for Win32 on
ia32
Many thanks
都是中国人就说中文吧^_^
明天会更好
On Sat, Sep 25, 2010 at 9:21 AM, Ma Xiaoming maxiaoming10...@hotmail.comwrote:
Hi Shawn,
You forgot to use -- before the option version. Try this instead
mysqladmin --version
Let us know your results.
Oh yes, it works. When I typed the right command:
太搞笑了,哈哈
2010/9/25 Neo neocana...@gmail.com
都是中国人就说中文吧^_^
明天会更好
On Sat, Sep 25, 2010 at 9:21 AM, Ma Xiaoming maxiaoming10...@hotmail.com
wrote:
Hi Shawn,
You forgot to use -- before the option version. Try this instead
mysqladmin --version
Let us know your results.
In the last episode (Sep 20), Pete Wilson said:
I'm pretty new to MySql, but not many years ago I was an ISAM guy so I
understand the issues with indexes and on-the-fly inserts.
I've seen many questions around this error message, Access denied; you
need the RELOAD privilege for this
- 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
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
Hi Jesse,
If you're specifying the password in plain text, you shouldn't put the
PASSWORD directive in there; you only use PASSWORD if you're using the
hashed password that MySQL will actually store.
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED
BY 'LongPasswordHere'
That was it. Once I removed PASSWORD, it went through, and I'm able to restart
MySQL now.
Thanks for your help.
Jesse
- Original Message -
From: Ian Simpson
To: Jesse
Cc: MySQL List
Sent: Tuesday, July 22, 2008 4:48 AM
Subject: Re: Access denied for user 'debian-sys
Do you login via sock or network ?
Didja change the passwd for localhost and % ?
--Original Message--
From: Jesse
To: MySQL List
Sent: Jul 21, 2008 17:35
Subject: Access denied for user 'debian-sys-maint'@'localhost'
OK. This is driving me Nutz 8-p
Any time I try to restart mysql, I
With assistance from a friend this issue has been rectified.
The current GRANT was not sufficient. After executing the new GRANT
with 'ALL PRIVILEGES' (using the --init-file switch) the root user can
now issue GRANTS.
Additionally I apologise for duplicate posts, It was not intentional.
On
Car Toper wrote:
More info...
I am able to login with the account via phpMyAdmin on the server.
Also, I am trying to use phpMyAdmin to change the permissions, but I
cannot figure out the syntax:
GRANT ON ppsntracker.* TO [EMAIL PROTECTED] WITH GRANT OPTION;
Cartoper
On 8/21/07, Car
More info...
I am able to login with the account via phpMyAdmin on the server.
Also, I am trying to use phpMyAdmin to change the permissions, but I
cannot figure out the syntax:
GRANT ON ppsntracker.* TO [EMAIL PROTECTED] WITH GRANT OPTION;
Cartoper
On 8/21/07, Car Toper [EMAIL PROTECTED]
Is this a user untz going to do even the create procedure, if yes then
you need to grant super previliege to this user.
grant super on *.* to 'untz'@'localhost' identified by 'password';
regards
anandkl
On 6/11/07, untz [EMAIL PROTECTED] wrote:
Baron Prathima,
Thank for the information!
Hi,
I think you need to log in as root and grant yourself some privileges then. If you
have lost the root password or root doesn't have privileges anymore either, there is a
chapter in the manual on how to do this: http://dev.mysql.com/
Cheers
Baron
untz wrote:
Baron Prathima,
Thank for
Ananda,
Thank you for responding!
I just tried this and got the following:
mysql grant super *.* to 'untz'@'localhost' identified by 'password';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to
untz wrote:
Ananda,
Thank you for responding!
I just tried this and got the following:
mysql grant super *.* to 'untz'@'localhost' identified by 'password';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
[mailto:[EMAIL PROTECTED]
Sent: Monday, June 11, 2007 4:02 PM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Subject: Re: Access Denied When Trying to Create Database
Ananda,
Thank you for responding!
I just tried this and got the following:
mysql grant super *.* to 'untz'@'localhost' identified
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 this
'
identified by 'password';
Not grant super *.* to 'untz'@'localhost' identified by 'password';
Regards,
Mikhail Berman
-Original Message-
From: untz [mailto:[EMAIL PROTECTED]
Sent: Monday, June 11, 2007 4:02 PM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Subject: Re: Access Denied When Trying
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,
Gerald,
I tried this and it still didn't work!
Raven:~ untz$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 223 to server version: 5.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql grant
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
, Rolando Edwards wrote:
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
Hi untz,
untz wrote:
Hello there,
I am using MySQL 5 on OS X Tiger...
After starting the server, I tried to create a sample database and this
is what what happened:
$ mysql -u untz -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to
Baron Prathima,
Thank for the information!
What happened is that I hadn't used MySQL for a long time and looked
up on the Internet on how to change my root and individual users'
passwords.
The last command the URL had me type was flush privileges; and once
I did that, I think it
Hi,
Please check the data directory where u have started your mysql has
permission ( mysql:mysql )
U would have started your ur mysql ar root user and when u create a
database which has
no permission as (mysql) in data directory.
This might help you out.
Kaushal Shriyan wrote:
Hi ALL
I am
On 6/9/06, Dilipkumar [EMAIL PROTECTED] wrote:
Hi,
Please check the data directory where u have started your mysql has
permission ( mysql:mysql )
U would have started your ur mysql ar root user and when u create a
database which has
no permission as (mysql) in data directory.
This might help
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
Hello.
Are you able to connect to MySQL Server if you blank the root password?
Use mysql command line client from 5.0 distribution. Have you run
mysql_fix_privilege_tables script? Please, provide the CREATE statement
for mysql.user table.See:
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 this?
Hello.
See:
http://dev.mysql.com/doc/mysql/en/access-denied.html
http://dev.mysql.com/doc/mysql/en/resetting-permissions.html
Seena Blace [EMAIL PROTECTED] wrote:
[-- text/plain, encoding 8bit, charset: iso-8859-1, 17 lines --]
Hi,
I have been noticing following
The reason i sthat you have not provided authorisation privileges to the
database or to the tables within the database for that user...
Very often we think granting all to the database is enough to make our app
work with a particular user - this may be true for some databases - but in
mysql
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
Hello.
It is strange that refusing message says you're not using passwords.
Does the problem disappear after the FLUSH HOSTS statement, instead of
restarting MySQL server?
Jorge Cambra Aused [EMAIL PROTECTED] wrote:
I have a web application running with Apache with PHP 4.1.2
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 ? :(
Hello.
Right. No need to FLUSH PRIVILEGES after GRANT.
My fault, sorry.
Michael Stassen [EMAIL PROTECTED] wrote:
Gleb Paharenko wrote:
Hello.
Execute FLUSH PRIVILEGES after granting.
See:
http://dev.mysql.com/doc/mysql/en/flush.html
Gleb Paharenko wrote:
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
Yes, please read this one. FLUSH PRIVILEGES is NOT needed after GRANT,
REVOKE, or SET PASSWORD. You only need to
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
Hello.
Are you doing FLUSH PRIVILEGES after granting?
Metal Host Contact [EMAIL PROTECTED] wrote:
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
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
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
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
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.
No, it didn't. I know it seems that way, but I'm sure that's not what happened.
I have tried
[EMAIL PROTECTED] wrote:
I didn't get a response to the question below, and my alternative solution
produced another error message as follows. Rather than try to establish a
new database, I used the Test database established when I reinstalled
mysql. With a csv file saved under
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-installed MySQL by rpm and when ever I try to issue
a command from the shell prompt, such as mysqladmin or mysqlshow, I would
(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?
Phil Ewington - 43 Plc [EMAIL PROTECTED] wrote:
Hi All,
I have just installed mysql-4.0.18 on my cobalt RaQ4 and for the first time
seemed to actually got somewhere! however, my existing PHP scripts failed to
connect to localhost as the password has not been set after the install. I
ran the
Jan Broermann [EMAIL PROTECTED] wrote:
Hi, I've got a little Excel Macro that connects to
MySQL via ADO below is the code. Funny thing is
it connects to the database and executes the truncate
orders without a problem.
But when I come to Load data in file i receive an
[MySQl][ODBC 3.5.1
Tim Cutts [EMAIL PROTECTED] wrote:
Server version: MySQL 4.0.18, running on Red Hat Linux 8.0
Symptoms: All our machines except for one can connect to the database.
That one machine gets 'access denied'.
All users are affected, even root.
SHOW GRANTS for an example user:
Grants
On 15 Mar 2004, at 15:35, Victoria Reznichenko wrote:
Probably you specified wrong password in the option file on
'bc-1-1-02' box.
Check the output of mysql --print-defaults.
Nice idea, but no - I typed the password in manually both times, and I
have repeated the experiment several times (and so
when establishing
connection.
(But I never tried to make connection from COBOL, I'm just using MYSQL C API
from C++)
- Original Message -
From: Arunachalam [EMAIL PROTECTED]
To: KKoTY [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 06, 2004 6:21 AM
Subject: Re: Access denied
PROTECTED]
Sent: Friday, February 06, 2004 6:21 AM
Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
I have installed MyODBC 3.51 and created the DSN for my Database.
I want to clarify that;
If the User name I have given is could not be resolved
You have attempted to login with out supplying a username. Try logging in
like:
mysql -uusername -ppassword
Original Message
On 2/5/04, 8:38:13 AM, Arunachalam [EMAIL PROTECTED] wrote regarding
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES):
Hi all,
Is any one met
Arunachalam wrote:
Hi all,
Is any one met with the error while connecting to MySQL Server
*Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)*
OK, you tried to log into mysql as [EMAIL PROTECTED], using a password.
if so pleass let me know the remedy to resolve this error.
I
this occures when you ommit the user name, MYSQL C API uses user ODBC as
default when you ommit or enter empty string as
user name when calling mysql_real_connect()
- Original Message -
From: Arunachalam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 3:38 PM
I have installed MyODBC 3.51 and created the DSN for my Database.
I want to clarify that;
If the User name I have given is could not be resolved by mysal_real_connect,
then it automatically establish the connection to the server using
[EMAIL PROTECTED] - right
If so, Is there need to have the
I get the following access denied error:
Warning: mysql_pconnect(): Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES) in
C:\Apache\Apache2\html\C2R\catalog\includes\functions\database.php on
line 17
Unable to connect to database server!
Why Is this happening and how can I fix
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
, 2003 6:24 AM
Subject: Re: access denied php my admin .
sorry for this late reply rory
i just got back to work ..
i am trying to connect to 192.168.x.y
but the jerk connects to 192.168.xx.xxx
the other ip
yeha it connects to an ip . not the loop back adrs
am i
Hi Toby
I am not an expert on permissions within mysql - boy, do I wish I was - but
could the problem be that you have only granted permissions to
[EMAIL PROTECTED] and not '[EMAIL PROTECTED]' ?
Here endeth my knowledge of MySQL permissions
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL
1 - 100 of 207 matches
Mail list logo