)
mysql CREATE DATABASE menagerie;
ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
You did not start mysql as root.
mysql -u root
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
the command-line 'mysql -u abcd'
* I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa'
o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
* As root I have executed 'USE mysql; SELECT USER,PASSWORD FROM USER' and have
verified the password
can login using the command-line 'mysql -u abcd'
* I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa'
o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
* As root I have executed 'USE mysql; SELECT USER,PASSWORD FROM USER' and have
verified
a password
xxyyzzaa
* I can login using the command-line 'mysql -u abcd'
Seems you connected as anonymous user. Check it with SELECT CURRENT_USER() function.
* I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa'
o ERROR 1045: Access denied for user: '[EMAIL PROTECTED
I figured this out. It's the ANY setup in Privileges. Being set to allow ANY user to
login without password, MySQL interestingly interprets
that as even known users with passwords MUST log in without passwords. My two
solutions were either to delete the ANY privileges or
to create a second
Jack Woehr wrote:
I figured this out. It's the ANY setup in Privileges. Being set to
allow ANY user to login without password, MySQL interestingly interprets
that as even known users with passwords MUST log in without passwords.
Well, that seems to be the effect, but that's not what it is doing.
Hello,
I would be happy to solve the following problem :
I get every week the following message on my Linux root mail account :
/etc/cron.daily/logrotate:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied
the docs)
mysqladmin -u root password new-password
I thought the above syntax would ask me for the password but it didn't now
all commands return
'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
How do I actually set a password, and more importantly, how do I reset the
password
the following command (obviously seriously misunderstood the docs)
mysqladmin -u root password new-password
I thought the above syntax would ask me for the password but it didn't now
all commands return
'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
How do I actually
.* TO [EMAIL PROTECTED] IDENTIFIED BY
'mysqlpassword'
GRANT ALL ON database.* TO mysqlusername\@'%' IDENTIFIED BY 'mysqlpassword'
But through script I cannot access the database it shows an error message
DBI connect ('lab:iidcm063.iidc.lucent.com','lrmt',...) failed: Access
denied for user: '[EMAIL
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 Driver][mysql-4.0.18-nt]Access denied for user
Driver][mysql-4.0.18-nt]Access denied for user
:'[EMAIL PROTECTED]' (using password: No)
But, access is set to usage and user and password are ok. So what's bugging
MySQL?
User must have FILE privilege to use LOAD DATA INFILE.
here is the code:
Set conn = New ADODB.Connection
With conn
Hi,When i run mysql,mysqlshow,mysqladmin etc from
mysql command,I receive following error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO)
I have RH9.
Please guide me.
Yours,Mohsen.
=
-DIGITAL SIGNATURE---
///Mohsen Pahlevanzadeh
.
Michael
Pahlevanzadeh Mohsen wrote:
Hi,When i run mysql,mysqlshow,mysqladmin etc from
mysql command,I receive following error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO)
I have RH9.
Please guide me.
Yours,Mohsen.
=
-DIGITAL SIGNATURE
I didn't found hostname.pid file.
SOS SOS
--- J.R. Bullington [EMAIL PROTECTED] wrote:
The next step is to shutdown mysqld, delete the
mysql and temp tables from
your /data/ folder, and then re-run the
scripts/mysql_install_db. That will
reinstall the mysql/hosts.frm, which will basically
hi,i was attemping,But my problem didn't solved.
SOS SOS
--- J.R. Bullington [EMAIL PROTECTED] wrote:
Did you change the mysql root password by running:
mysqladmin -u root password 'newpassword'?
If so, try:
mysql -u root -p
It will then prompt you to enter a password.
J.R.
The next step is to shutdown mysqld, delete the mysql and temp tables from
your /data/ folder, and then re-run the scripts/mysql_install_db. That will
reinstall the mysql/hosts.frm, which will basically reset your root user and
password. However, it will also kill any users you have created.
To
Hi.
When i run mysql,mysqlshow,mysqladmin or .,I
receive following error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO)
Please guide me..
Yours,Mohsen.
=
-DIGITAL SIGNATURE---
///Mohsen Pahlevanzadeh
Network
Did you change the mysql root password by running:
mysqladmin -u root password 'newpassword'?
If so, try:
mysql -u root -p
It will then prompt you to enter a password.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
wc_jpo
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
and, similarly, the web script cannot get in. Yet when I select the user
record from mysql.user and mysql.db they appear complete.
What glaringly obvious omission have I failed to see?
TIA
all privileges on wc_jpo.* to wcjporoot identified by 'pass'
with grant option ;
flush privileges ;
and similarly for ... wcjporoot@% ... but still cannot get in;
whenever I try with the mysql client I get
bash-2.05a$ mysql -uwcjporoot -p wc_jpo
Enter password:
ERROR 1045: Access
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
and, similarly, the web script cannot get in. Yet when I select the user
record from mysql.user and mysql.db they appear complete.
What glaringly obvious omission have I failed to see?
Remove
but access denied
David T-G [EMAIL PROTECTED] wrote:
I have just moved my web site from one server to another (whew!) and I am
having a problem with a mysql user definition for a calendar program.
I used mysqldump to dump the calendar database (wc_jpo) and loaded it on
the new server; it appears
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Rick, et al --
...and then Rick Emery said...
%
% OFF TOPIC
%
% Remove space between '-p' and the password in you command line.
% That isbash-2.05a$ mysql -uwcjporoot -pwc_jpo
Actually, wc_jpo is the name of the database, and -p without a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Egor, et al --
...and then Egor Egorov said...
%
% David T-G [EMAIL PROTECTED] wrote:
%
% I have just moved my web site from one server to another (whew!) and I am
% having a problem with a mysql user definition for a calendar program.
...
%
David T-G [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Egor, et al --
...and then Egor Egorov said...
%
% David T-G [EMAIL PROTECTED] wrote:
%
% I have just moved my web site from one server to another (whew!) and I am
% having a problem with a mysql
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 for [EMAIL PROTECTED]: GRANT ALL PRIVILEGES
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
Hello,
I am having a hard time getting Mysql to let [EMAIL PROTECTED] connect.
I am constantly getting this:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
when I issue mysql -u root
I can log in if I use mysql -h 192.168.1.10 -u root mysql
I guess I have some
privileges;
Now logout, and login again using the new password and the new user!
voilà!
Best Regards!
On Fri, 2004-03-12 at 09:25, Leslie Vance wrote:
Hello,
I am having a hard time getting Mysql to let [EMAIL PROTECTED] connect.
I am constantly getting this:
ERROR 1045: Access denied for user
and I enter it.
Then it beeps and gives me this error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' Using
password: YES
I am at a loss as to what to do.
Please help.
Thanks
Rob
Hello Rob,
Friday, March 12, 2004, 7:39:47 PM, you wrote:
RA ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' Using
password: YES
Does that user actually exist within MySQL? I have you used the
mysqladmin program and created a user account called ackerley? If not,
that's why you can't
Is this user a super user, or do they only have access to a single DB?
If they are a super user, try changing the password using mysqladmin -u
ackerley password 'newpassword'
If this user only has access to a single db, alter your mysql command to:
shell mysql -u ackerley -p 'database_name'
Then like Richard Davey sent earlier to the list, try:
shell mysql -u root
If you haven't created the users yet with the mysql tool, then your user
won't have access to it. First, change the root password using:
shell mysqladmin -u root password 'new_password'
Then log into mysql and use:
mysql
try to create user named ODBC, and you will see,
also it writes Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)*,
so you are using some password, and question is from where this goes, and
which
password you have to give to user ODBC.
I still thing that you must omit some parameter
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
Hi all,
Is any one met with the error while connecting to MySQL Server
*Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)*
if so pleass let me know the remedy to resolve this error.
I don't have the user named ODBC in my mysql Database.
my configuration is:
Windows 2000
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
Subject: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Hi all,
Is any one met with the error while connecting to MySQL Server
*Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)*
if so pleass let me know the remedy to resolve this error.
I don't have
PM
Subject: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Hi all,
Is any one met with the error while connecting to MySQL Server
*Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)*
if so pleass let me know the remedy to resolve this error
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
Hello,
I'm trying to access phpadmin and another website that I built on my
mysql server and 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
new users and copying all settings of the default root
user (which I've not set a PW for cuz I loose access to the main DB when I
do that) ... nomatter what, all users can access the DBs fine when no pw is
set, but if a pw is set, MySQL reports access denied...
and yes, it actually also does
on the network with an
access denied message.
Perl script used to test:
#!/usr/bin/perl
use DBI;
# Set up the DB connection
my $dsn = dbi:mysql:host=192.168.0.201;database=test;
my $user = user;
my $password = password;
$goodcount = 0;
$errorcount = 0;
$bar = 0;
while ($bar 1000) {
$dbh = DBI
On Tuesday 25 November 2003 16:25, you wrote:
is the access control by hostname or ipnumber? if by name, you could be
running into a dns failure on the inverse map lookup.
IP based - the machines communicate over an internal-only network on their
second network card.
--
MySQL General
) the server
will
reject the attempted connection from another host on the network with an
access denied message.
snip
I'm also seeing the same intermittent failures in my PHP scripts.
Linux text.box.invalid 2.4.20-20.9 #1 Mon Aug 18 11:45:58 EDT 2003 i686
i686
i386 GNU/Linux
RedHat 9 based system
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
Hello,
i've just installed the 3.23.57 version in my account and i don't have root
privileges. The problem is the if i try to create a database, like this
mysql create database example;
i get the following message:
Error 1045: Access denied for user : '@localhost'.
Is this because i'm
the 3.23.57 version in my account and i don't have root
privileges. The problem is the if i try to create a database, like this
mysql create database example;
i get the following message:
Error 1045: Access denied for user : '@localhost'.
Is this because i'm not the root?
If i try to use
,
i've just installed the 3.23.57 version in my account and i don't have
root
privileges. The problem is the if i try to create a database, like this
mysql create database example;
i get the following message:
Error 1045: Access denied for user : '@localhost'.
Is this because i'm
just press the power button to shut it off?
Aaaa!
Patrick
-Original Message-
From: Nils Valentin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 8:18 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Error 1045: Access denied...
Hi
'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql create table test (testi integer not null,PRIMARY KEY (testi))
type=MyISAM;
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database
'Dstats_Stats'
Can someone please help me ?
I don't know what i'm doing wrong, all my MySQL
, 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
hay guyz
im a bit stuck
first i couldnt get any user but root to log into mysql
on command prompt and myadmin
now i can ,et my user to log in through command prompt but i get this weired
error for myadmin
Error
MySQL said:
Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES
PROTECTED]
There are 10 kinds of people in this world,
those who understand binary and those who don't (Unknown)
- Original Message -
From: toby - [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 8:57 AM
Subject: access denied php my admin .
hay guyz
im
thnx rory
the thing is kwexchange is localhost you know .
so it should work
alwayz has before this dammed day .
anywayz .
i did install mysql on another machine and installed all the rest , php,
apache, phpmyadmin on another
when it gave me these access denied errors
who understand binary and those who don't (Unknown)
- Original Message -
From: toby - [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:18 AM
Subject: Re: access denied php my admin .
thnx rory
the thing is kwexchange is localhost
with this thing ..
:'(
thnx a bill
toby
From: Rory McKinley [EMAIL PROTECTED]
To: toby - [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: access denied php my admin .
Date: Thu, 9 Oct 2003 11:47:25 +0200
Hi toby
If I log in to mysql via the command line on the hosting machine it says
I am having intermittent access problems with MySQL and phpBB... I am
unsure
if it is a problem with MySQL, FreeBSD or php, leaning towards MySQLso i
figured i'd try my luck here.
I setup a small forum (7-8 users) that uses phpBB, and I am getting
intermittent access denied errors when accessing
Hi list,
I am invoking mysql through php, so when i try to
connect,
it gives me this error messageas i connecting
mysql as
localhost to 'database' database. While I dind't
specify
user/passwd for
that.
Access denied for user: '@localhost' to database
'database'
Thanks
'database' too (which you can
call whatever you want, of course) for this to work.
Best regards,
Haakon Nilsen
- Original Message -
From: ketvin
To: [EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 11:23 AM
Subject: Access denied
Hi list,
I am invoking mysql through php
At 06:04 PM 9/21/03 -0700, Ray Tayek wrote:
hi, trying out opnecms. so i installed mysql on slak 8.0. added a root
password (something like ... root password opencms) like the doc says, so
i can do a: use mysql and create databases and tables if am root on the
slak box. but only if i am root.
Does anyone think I would have better luck installing MySQL with something
other than an RPM??
-Original Message-
From: James M Kupernik [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 11:59 AM
To: 'mos'
Cc: [EMAIL PROTECTED]
Subject: RE: random access denied
Thank you
It's not a continued access denied, because it can accept connections all
day long, but randomly it will just deny one, but the accept it on the next
try.
I've googled this problem to death, I don't know what else I can do
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent
At 11:17 AM 9/18/2003, you wrote:
It's not a continued access denied, because it can accept connections all
day long, but randomly it will just deny one, but the accept it on the next
try.
I've googled this problem to death, I don't know what else I can do
James,
Are you sure it's not something
to goes through.
Jamie
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 11:37 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: random access denied
At 11:17 AM 9/18/2003, you wrote:
It's not a continued access denied, because it can
access denied
Hello,
I am having a frustrating problem with MySQL. I don't consider myself a
newbie, nor am I a master, but either way I can't figure out this problem
and I'm hoping someone here has an idea of what is going wrong.
Every so often MySQL decides it doesn't want to authenticate a user
+for+user%22btnG=Google+Search
There are quite a few suggestions listed there.
Mike
-Original Message-
From: James M Kupernik [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 3:58 PM
To: [EMAIL PROTECTED]
Subject: random access denied
Hello,
I am having a frustrating problem
matter on the user/db, etc;. The error message is: 030916 16:10:50 39
Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
I have a whole log full of these messages. Now and soon as the page is
refreshed or you try logging in again (from the command line) it goes
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 PROTECTED
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
Michael Harly [EMAIL PROTECTED] wrote:
I try to improve the security on the mysql and now I can't get into it.
I get this massage.
?Access denied for user: '@localhost' to database 'mysql' ?
It means that there is no entry in the table user for 'your_user'@'localhost'. Where
'your_user
I try to improve the security on the mysql and now I can't get into it.
I get this massage.
Access denied for user: '@localhost' to database 'mysql'
Is the same throw webmin or phpMyAdmin
Can anybody please help
Im runnin Redhat 7.3 and mysql 3.23.56
/harly
--
MySQL General Mailing List
now allowing clients to login but I'm not sure what would cuse it not to
allow root to change the password, I dubble and triple checked my entry
but still nothing happens. Once I login to root I do the following
mysql use mysql
mysql UPDATE user SET Password= ('x')
- WHERE
I figured it out. Actualy silly me forgot to add the password() function
how embarising. :)
--
Jerry M. Howell II
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hey there all,
Here is the problem I am haveing and was wondering if anyone can help
me here. I was getting the following error when loging into mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
After searching for an answer I found the answer
. Howell II [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 1:24 PM
To: [EMAIL PROTECTED]
Subject: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
Hey there all,
Here is the problem I am haveing and was wondering if anyone can help
me here. I
On Fri, Sep 05, 2003 at 01:34:01PM -0400, Fortuno, Adam wrote:
Jerry,
Don't forget that MySQL authenticates an entity, which is based on the user
name and host. For example, on my MySQL boxes root can only login from the
localhost. If I attempt to login with root from another host, I am
.* to 'elmasri'@'%' identified by 'navathe';
Query OK, 0 rows affected (0.00 sec)
mysql quit
Bye
C:\temp\Menagerie_01mysql -u elmasri -pnavathe company
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
===
However if I use only the grant statement,
I don't need any
of MySQLFront or
PHPMyAdmin.(4.3) so I assumed maybe the MySQL had becomedamaged -
so I uninstalled it and reloaded it (leaving the data files
untouched).
Now I cannot get in at all and it simply tells me that error
1045 - access denied for user root 127.0.01 which leaves me
stumped.
Meanwhile
but didnt find any clue
i didnt set any password .
mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
Did you have MySQL server installed before?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored
Estoy tomando el sol
.
q
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Programmer
www.programEz.net
-Original Message-
From: Helen [mailto:[EMAIL PROTECTED]
Sent: Friday, July 18, 2003 4:57 AM
To: [EMAIL PROTECTED]
Subject: access denied
mysql CREATE DATABASE csttrainrep
- ;
ERROR 1044: Access denied for user: '@localhost' to database
Jason - I just tried:
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'X'
on the server machine in a mysql console and I got the following:
ERROR 1045: Access denied for user: '@localhost' using password: NO
...in addition to my questions below, why doesn't that work! Ahhh
/mysqltest.php
I get the following error (I've attached my mysqltest.php file too):
'Warning: mysql_connect(): Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES) in
C:\Apache\Apache2\html\mysqltest.php on line 20
Could not connect'
*** Note, I had to change my router settings to forward port
mysql CREATE DATABASE csttrainrep
- ;
ERROR 1044: Access denied for user: '@localhost' to database
'csttrainrep'
mysql GRANT ALL ON csttrainrep. TO helen
- ;
ERROR 1064: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right
-u abc -pabcpass myFineDb
Works fine in Debian (.49) but not in fink (.56):
[mac:~] reuleaux% mysql -u abc -pabcpass myFineDb
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'myfinedb'
[mac:~] reuleaux%
If I look closer at the problem I see that I can at least log
) but not in fink (.56):
[mac:~] reuleaux% mysql -u abc -pabcpass myFineDb
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'myfinedb'
[mac:~] reuleaux%
If I look closer at the problem I see that I can at least log in
but not use the database:
[mac:~] reuleaux% mysql -u abc
.* to [EMAIL PROTECTED] identified by abcpass;
Query OK, 0 rows affected (0.00 sec)
mysql Bye
[mac:~] reuleaux% mysql -u abc -pabcpass myFineDb
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'myfinedb'
[mac:~] reuleaux%
(The same with -h 192.168.1.5)
On Mon, Jul 14
and .56)
or by the fink configuration - I might ask at the fink-users list
later.
Works fine in Debian (.49) but not in fink (.56):
[mac:~] reuleaux% mysql -u abc -pabcpass myFineDb
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'myfinedb'
[mac:~] reuleaux
On Mon, Jul 14, 2003 at 03:14:33PM +0200, Sergei Golubchik wrote:
...
You could've noticed that it tries to access different database. You
granted access to 'myFineDb', but you weren't able to access 'myfinedb'.
So, it's case sensitivity issue. On Debian everything is ok, of course,
on Mac
NEWBIE
I have make a mistake using mysqlcc;
now, user (mysql,root,bruno) can't acces to databases.
I use both mysqlcc phpMyAdmin but the answer is
access denied [EMAIL PROTECTED] (Using password:Yes)
access denied [EMAIL PROTECTED] (Using password:Yes)
Please an help
Thanks in advance
bruno
://www.analysisandsolutions.com/code/mybasic.htm
Good luck...
bruno [EMAIL PROTECTED] 07/10/03 12:29PM
NEWBIE
I have make a mistake using mysqlcc;
now, user (mysql,root,bruno) can't acces to databases.
I use both mysqlcc phpMyAdmin but the answer is
access denied [EMAIL PROTECTED] (Using password:Yes
przemys?aw ho?ubowski [EMAIL PROTECTED] wrote:
Somehow I managed to make all users (root also) unable to access and use
'mysql' database, and so I cannot fix it. Could you tell me how to fix it?
No matter what user I use to get access finally I get: ERROR 1044: Access
denied for user
Hi,
Somehow I managed to make all users (root also) unable to access and use
'mysql' database, and so I cannot fix it. Could you tell me how to fix it?
No matter what user I use to get access finally I get: ERROR 1044: Access
denied for user: '@localhost' to database 'mysql'.
The only database I
:
Access Denied for user: [EMAIL PROTECTED] (Using password: NO)
This situation has happened 3 times and I had to reinstall MySql and start from scratch.
Can someone please point me in the right direction, this is my first try and it has been quite a serious learning experience.
Thank you in advance
create a password for the root [EMAIL PROTECTED], I start getting
access denied for root [EMAIL PROTECTED] 127.0.0.1 And then I cannot get into the
database anymore.
I also should note that when I use phpmyadmin and look at databases, I see the mysql
database but when I look at the privileges
201 - 300 of 580 matches
Mail list logo