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
Shane,
Maybe I can lend a hand.
When you first install MySQL, there is (basically) only one user root. The
root user exists without a password, which is why pretty much everyone
recommends that you assign root a password immediately. You're first
command:
mysqladmin -uroot password
Can you exp
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,
I have installed MySQL v4.0.13
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=''
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
Why not try sql to update it:
mysql -u root
mysql > use mysql;
mysql> update user set password = password('new password') where user =
'root';
mysql> flush privileges;
mysql> exit
- Original Message -
From: "Michael Nezi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 2
10 matches
Mail list logo
