Re: Changing root password
If you have just finished installing, then root has no current password and you can leave out the -p altogether: root@localhost bin]# ./mysqladmin -u root password 'new-password' good luck Richard Ward Jay Paulson [EMAIL PROTECTED] 01/16/02 12:57AM I'm trying to change the root password for mysql. This is the first time I've tried to change the password and I can't get it to work. Below is the error message I get: [root@localhost bin]# ./mysqladmin -u root -p password 'new-password' Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I've looked at the manual and it doesn't say much that I've already done. I've also looked up the --skip-grant-tables but the only mysqld file I have to run is in the /etc/rc.d/init.d/ directory and it doesn't take the --skip-grant-tables flag. So I'm at a lost at what to do next. thanks. -- Content-Type: text/plain; Content-Disposition: attachment; filename=disclaimer.txt . Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php . . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Changing root password
Skip the -p. You have no current password . Jay Paulson wrote: I'm trying to change the root password for mysql. This is the first time I've tried to change the password and I can't get it to work. Below is the error message I get: [root@localhost bin]# ./mysqladmin -u root -p password 'new-password' Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I've looked at the manual and it doesn't say much that I've already done. I've also looked up the --skip-grant-tables but the only mysqld file I have to run is in the /etc/rc.d/init.d/ directory and it doesn't take the --skip-grant-tables flag. So I'm at a lost at what to do next. thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Changing root password
I'm trying to change the root password for mysql. This is the first time I've tried to change the password and I can't get it to work. Below is the error message I get: [root@localhost bin]# ./mysqladmin -u root -p password 'new-password' Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I've looked at the manual and it doesn't say much that I've already done. I've also looked up the --skip-grant-tables but the only mysqld file I have to run is in the /etc/rc.d/init.d/ directory and it doesn't take the --skip-grant-tables flag. So I'm at a lost at what to do next. thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Changing root password
The file in the /etc/rc.d/init.d is likely called S95mysql, and you CAN add that parameter to that file. You'll need to edit the file, and add something like this: /opt/mysql/bin/mysqld \ --basedir=opt/mysql \ ... --skip-grant-tables \ ... /var/log/mysql/mysql.err 21 The ...'s above are other parameters that may or may not be there. -Original Message- From: Jay Paulson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 4:57 PM To: [EMAIL PROTECTED] Subject: Changing root password I'm trying to change the root password for mysql. This is the first time I've tried to change the password and I can't get it to work. Below is the error message I get: [root@localhost bin]# ./mysqladmin -u root -p password 'new-password' Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I've looked at the manual and it doesn't say much that I've already done. I've also looked up the --skip-grant-tables but the only mysqld file I have to run is in the /etc/rc.d/init.d/ directory and it doesn't take the --skip-grant-tables flag. So I'm at a lost at what to do next. thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JDBC Issue After changing root password.
Hello,
I have been using JDBC with MySQL for the past couple of days without any user id or
password. After reading the directions in the privileges section I decided to change
the password for root. I used the following example from the online manual:
shell mysql -u root mysql
mysql UPDATE user SET Password=PASSWORD('new_password')
WHERE user='root';
mysql FLUSH PRIVILEGES;
After doing this I was able to sign on to mysql as follows:
mysql -u root -ptwosouth mysql
This works fine and I am able to review the tables in the mysql database with the
interactive client.
Here is a snippet of java code that I am using to read a table from the database.
try {
System.out.println(Createing Connection);
Connection Conn = DriverManager.getConnection(
jdbc:mysql://165.121.243.45/test?user=rootpassword=twosouth);
// jdbc:mysql://165.121.243.45/test);
try {
...
I get the following errors
SQLException: Server configuration denies access to data source
SQLState: 08001
VendorError: 0
Prior to changing the root password I was able to access the database with JDBC with
no user or password. Now, I am unable to get a connection even with the correct user
and password.
What am I missing?
Thanks in advance,
Scott Salisbury
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
