Hello.
> I have also tried mysqld_safe --skip-grant-tables --user=root &
Don't run mysqld under root (even more - fresh versions should
automatically skip this option). What exactly have you done to
restore root password? Please provide exact SQL statements.
What user is 'Access denied' er
I tried to go into mysql with root and the password I had set, and access was
refused.
I finally gave up and decided to reset the root password using the techniques
described on
http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html
This is a linux machine running mysql Your MySQL co
Hello.
If MySQL throws 'Access denied', have a look here:
http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html
Your version of MySQL is very old and have lots of bugs, I recommend you
to upgrade.
Zan B. wrote:
> Hello all!
>
> I wanted to discuss a problem I am having wi
Zan B. wrote:
Hello all!
I wanted to discuss a problem I am having with setting up MySQL.
I noticed that my root password isn't set. When i try to set it via
phpMyAdmin, MySQL doesn't recognize my databases, and denies all
connections. Now I've tried setting the password via SSH by accessing
Hello all!
I wanted to discuss a problem I am having with setting up MySQL.
I noticed that my root password isn't set. When i try to set it via
phpMyAdmin, MySQL doesn't recognize my databases, and denies all
connections. Now I've tried setting the password via SSH by accessing
the MySQL prom
Jesse <[EMAIL PROTECTED]> wrote:
> anyone know why the mysql daemon fails to start after I set the root
> password according to this:
>
> http://dev.mysql.com/doc/mysql/en/Default_privileges.html
>
> I use the command:
>
> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
> SET PASSWORD
anyone know why the mysql daemon fails to start after I set the root
password according to this:
http://dev.mysql.com/doc/mysql/en/Default_privileges.html
I use the command:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
SET PASSWORD FOR 'root'@'host_name' = PASSWORD('newpwd');
This is
e Korosec [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 9:30 PM
To: [EMAIL PROTECTED]
Subject: Setting root password on OS X
I am a new mysql user. I am installing MySQL for the first time on my mac. I
need to set a password for the 'root' user by using the following 2
commands:
I am a new mysql user. I am installing MySQL for the first time on my mac. I
need to set a password for the 'root' user by using the following 2
commands:
/usr/local/mysql/bin/mysqladmin -u root password
/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password
The first worked, but i get
Rob Yale wrote:
Hi folks,
The following is copied exactly from my machine, except for the munged
password. Setting the root password can't be completed, because the host
apparently can't connect the mysql server. What am I doing wrong?:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USE
Hi folks,
The following is copied exactly from my machine, except for the munged
password. Setting the root password can't be completed, because the host
apparently can't connect the mysql server. What am I doing wrong?:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done
John Utting wrote:
Hi,
I have installed MySQL v4.0.13 on a Win2K machine. the installation
directory is C:\mysql
I've installed it as a service using 'mysqld-nt -install' and the service is
running.
I've checked to se that it is working using 'mysqlshow', 'mysqlshow mysql' &
'mysqladmin version s
Try setting the user as [EMAIL PROTECTED]
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "John Utting" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, 14 June, 2003 07:57
Subject: Setting root password
Hi,
Hi,
I have installed MySQL v4.0.13 on a Win2K machine. the installation
directory is C:\mysql
I've installed it as a service using 'mysqld-nt -install' and the service is
running.
I've checked to se that it is working using 'mysqlshow', 'mysqlshow mysql' &
'mysqladmin version status proc'. All
Art,
Thursday, August 15, 2002, 4:53:26 PM, you wrote:
AF> Still could not get it to work so I uninstealled and reinstalled. Will use
AF> the anonymous login etc util I figure out this security system. Is there a
AF> document that explains the password system in laymans terms?
You can find info
]]
Sent: Thursday, August 15, 2002 4:08 AM
To: [EMAIL PROTECTED]
Subject: Re: Setting root password in mysql for windows
Art,
Thursday, August 15, 2002, 7:12:40 AM, you wrote:
AF> Having a hard time coming to grips with the password setup for mysql in
AF> windows. I follow the instructions
Art,
Thursday, August 15, 2002, 7:12:40 AM, you wrote:
AF> Having a hard time coming to grips with the password setup for mysql in
AF> windows. I follow the instructions below from the documentation.
AF> C:\> C:\mysql\bin\mysql mysql
AF> mysql> DELETE FROM user WHERE Host='localhost' AND User=''
Having a hard time coming to grips with the password setup for mysql in
windows. I follow the instructions below from the documentation.
C:\> C:\mysql\bin\mysql mysql
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
mysql> QUIT
C:\> C:\mysql\bin\mysqladmin reload
C:\> C:\mysql\bin\mysq
What version have you installed? I would think on Mac OS X you have 3.23.36?
I will give it one last shot. First kill -9 the mysql processes
(mysqladmin shutdown does not work on Mac OS), killing safe_mysql
first. Add a -p when assigning the password, and I think that the
password needs to be
gt;
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 26, 2001 5:42 PM
Subject: setting root password in mysql
> Never am able to gain access to enter in a password for root?
>
> It's driving me crazy...
>
> Any help>>
>
> Michael Collins thanks for trying!
>
&g
Never am able to gain access to enter in a password for root?
It's driving me crazy...
Any help>>
Michael Collins thanks for trying!
[localhost:/Users/nezi] root# kill -9 1354
[localhost:/Users/nezi] root# kill -9 1371
[localhost:/Users/nezi] root# cd /usr/local
[localhost:/usr/local] root# .
21 matches
Mail list logo
