FYI,
I don't think this was sent to the list, forgive me if it was and I
didn't see it.
Andy
--
You probably don't have to reinstall it. If you never gave root a
password, just login as Andy says below and, when prompted for the
password, just press the ENTER key. Unless you gave root a password and
forgot it, you should find yourself in the mysql program. Enter
something like:
update mysql.user set password = password('<new pwd>') where user = 'root';
flush privileges;
There are other ways to change a pwd, but I use that since it's easier
for me to remember one way.
Jim
On Mon, Aug 18, 2008 at 3:07 AM, Andy Shellam
<[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Hi Andrew,
I think he means re-install MySQL and provide a root password (you
said when you originally installed it that you didn't give it a
password.)
After you've done this, try mysql from the command-line explicitly
telling it to use the user "root":
mysql --user=root --password
The "--password" here tells mysql to prompt you for a password, or
alternatively you can provide the password on the command-line too:
mysql --user=root --password=<password>
Once you can login via the command-line there's no reason why the
Admin GUI shouldn't be able to login too.
Regards,
Andy
Quoting AndrewMcHorney <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>:
How does one done this?
At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote:
Hi Andrew
As per your Question , you can test with the below
solution :-
Try to reconfigure MySQL by providing the root
password and then
try to run the
administer GUI. This should solve the problem.
CHAVA
On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney
<[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>wrote:
Hello
I am still getting the MySQL Error Number 1045 Access
denied error message
when running the adminstrator gui. I attempted to start
mysql from the dos
command line via "mysql" and I am getting the following.
ERROR 1045 (28000):
Access denied for user 'ODBC'@'localhost' (using
password: NO). I am
logging in as root, locahost and no password because I
did not enter one
when I installed the software. I will be changing that.
For the command line
I just entered mysql and a return. How can I fix this. I
am off for the week
and I would like to get this working so I can create a
database or 2.
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Sreekanth CHAVA
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release
Date: 8/16/2008 5:12 PM
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Andy Shellam
Business Systems Architect
Network Mail
NetServe Support
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
