%.corp.domain.in| testuser | *FJHHEU5746DDHDUDYDH66488 |
+---++---+
and skip_networking is OFF
*Mysql Version : 5.1.58-log*
root@Serv1:~# mysql -utestuser -p@8AsnM0! -h $(hostname)
ERROR 1045 (28000): Acces
ok
I have tried these :
ifconfig -a
lo0: flags=8049 mtu 16384
inet6 ::1 prefixlen 128
inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1
inet 127.0.0.1 netmask 0xff00
gif0: flags=8010 mtu 1280
stf0: flags=0<> mtu 1280
fw0: flags=8863 mtu 4078
lladdr 70:cd:60:ff:fe:eb:72:ea
media:
Hi
> > > | | ericomtxmacbookpro.local |
> > *E85DC00A0137C6171923BE35EDD809573FB3AB4F |
> > >
>
mysql> DELETE FROM mysql.user WHERE user='';
mysql> FLUSH PRIVILEGES;
maybe helps?
Cheers
--
Claudio
+---+
> > 5 rows in set (0.00 sec)
> >
> > all passwords are filled in the db ...
> >
> > also ... I can connect through command line
> >
> > what I can't do is :
> > 1. connect or even ping ins
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 :
>
> http://localhost/mysql
fer-Encoding: quoted-printable
Please 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 den
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* a
*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*
http://dev.mysql.com/doc/re
gt;> 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 error :
>>>
>>> Access denied for user 'root
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 conne
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
he
> manual
> > that corresponds to your MySQL server version for the right syntax to use
> > near 'to *.* 'root'@'127.0.0.1' identified by kernel26' at line 1
> It's my error :) It should be:
>
> mysql> grant all privileges on *.* to
ur MySQL server version for the right syntax to use
> near 'to *.* 'root'@'127.0.0.1' identified by kernel26' at line 1
It's my error :) It should be:
mysql> grant all privileges on *.* to 'root'@'127.0.0.1' identified by
'kernel26'
by kernel26' at line 1
...
in eclipse using jconnector ... I get the same error :
when pinging :
java.sql.SQLException: Access denied for user 'root'@'localhost' (using
password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQL
or. Commands end with ; or \g.
>> Your MySQL connection id is 97
>>
>> Server version: 5.6.15 MySQL Community Server (GPL)
>>
>>
>>
>>
>> but using 127.0.0.1 no :
>>
>> ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h 127.0.0.1
&
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h 127.0.0.1
> -P 3306
> Enter password:
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)
> ericomtxmacbookpro:bin ericomtx$
>
>
>
> 2014/1/13 Erick Oc
monitor. Commands end with ; or \g.
Your MySQL connection id is 97
Server version: 5.6.15 MySQL Community Server (GPL)
but using 127.0.0.1 no :
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h
127.0.0.1 -P 3306
Enter password:
ERROR 1045 (28000): Access denied for user
ro: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 er
r. 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 error :
>>
>> Access denied for user 'root'@'localhost' (using password: YES)
>>
but in the browser I get the error :
>
> Access denied for user 'root'@'localhost' (using password: YES)
>
> I can't find any information in error log and access log
>
> is there any command parameter that I should use when starting mysql so
> thi
. Type '\c' to clear the current input
statement.
mysql>
...
but in the browser I get the error :
Access denied for user 'root'@'localhost' (using password: YES)
I can't find any information in error log and access log
is there any command parameter th
Gurus,
I'm running a Windows Server 2003 cmd shell script to backup my databases using:
%mysqldir%\bin\mysqldump -B %dbname% -u %dbuser% -p%dbpass% >
%bkupdir%\dbBkup_%dbname%_%yy%%mm%%dd%.sql
@ECHO Done! New File: dbBkup_%dbname%_%yy%%mm%%dd%.sql
It's been running fine until I've had to change
;mysqladmin" -p root shutdown next the root password
> was
> > asked for,I entered the correct password, when I entered the password the
> > below displayed error was the result
> >
> > mysqladmin: connect to server at 'localhost' failed
> > error: 'Acc
sword was
> asked for,I entered the correct password, when I entered the password the
> below displayed error was the result
>
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'ODBC'@'localhost' (using pa
utdown MySQL service from the command line
and ran the command "mysqladmin" -p root shutdown next the root password was
asked for,I entered the correct password, when I entered the password the
below displayed error was the result
mysqladmin: connect to server at 'localhost'
the result
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
How can I correct this?
Is this because of a firewall preventing access to port 3306?If a firewall
is preventing access how w
server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
How can I correct this?
Is this because of a firewall preventing access to port 3306?If a firewall
is preventing access how was it able to ask for th
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 '
MySQL normally only checks the privilege tables on start-up.
On Mon, 2008-07-21 at 20:35 -0400, Jesse wrote:
> OK. This is driving me Nutz 8-p
>
> Any time I try to restart mysql, I get the error, "Access denied for user
> 'debian-sys-maint'@'localhost'"
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
OK. This is driving me Nutz 8-p
Any time I try to restart mysql, I get the error, "Access denied for user
'debian-sys-maint'@'localhost'"
My understanding is that the password for the debian-sys-maint user is found
in /etc/mysql/debian.cnf So, I edit that, a
Hello MySQL List,
Thanks Ken and HongKong0888 for the advice and suggestions.
I hate when these kinds of problems just "fade away" with no
resolution or analysis of the resolved issue. So, with that,
here is the explanation for what caused THIS particular
problem (can you say user error?).
In re
My guess is that you have the privileges set on your local box that
allow connections with those credentials but the same privileges are
not set up on your clients machines.
Although using apache as a user without a password is quite a security
risk. And then mailing those details to a public mail
Hello mysql,
I just started having this problem and wonder if someone might give me
a clue why this is happening. The scenario is that I build a CMS on my
local XP system to make sure it is working correctly and customize it
per the client's specifications. Almost always the client has some
versio
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
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]> wro
I have a MySql server running on a Windows box that I cannot connect
to from another machine. I first checked to make sure the user has
the correct permissions, which the user does, it has the %. I did
read something that gave me the impression the user needs to have a
tranditional windows accoun
ew-password'
You 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
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,
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 '/u
s Armstrong <[EMAIL PROTECTED]> wrote:
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'@
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)
---
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)
---
Aron 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
ing 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 ("%"),
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
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'
(using password: YES)
[EMAIL PROTECTED] ~]#
I already checked the user was configured for
11:48 AM, Aron 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 deni
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'
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
i
the error 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 str
lication 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:
&
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 for
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
Hello.
> mysqladmin:connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)'
...
> shell>safe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid
> --skip-grand-tables &
> [1] 28712
> shell> Sta
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
(yourpass
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 di
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 o
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 pass
][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
' . mysql_error() .
'');
}
}
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 f
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'; //dat
}
}
-Original Message-
From: 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 my
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 can
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 user
* to [EMAIL PROTECTED] identified 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.
>
>
rnel-Hacker!!! [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 ta
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 c
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.
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 ex
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 m
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 t
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
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]
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?
>
http://dev.mysql.com/doc/mysql/en/User_Account_Mana
en, Long P (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
get the error of
'Access denied for user: '[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://li
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]'
(Using password: NO)'.
Could someone
hen, I try to connect to the database using the host parameter but I
> get the following error message:
>
> # mysql --user=foo --password=password -h host foo
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
>
> I've only mana
# 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 the
sec)
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
sql> 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?
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 doi
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 ac
"abcd" and used MyPHPAdmin to give this user 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
word
"xxyyzzaa"
* I 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 execut
aa"
* I 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; SEL
cess denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
I l
t been set after the install. I
> ran 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
>
>
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, ho
[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','
ons.html> in the manual.
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,M
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
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 basi
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 r
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.
>
>
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:http://lists.mysql
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
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
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'
J.
1 - 100 of 192 matches
Mail list logo