How to: MySQL

[mzainal]

Hi,

I finish doing installation for MySQL 5.1 using rpm. So now, i want to login to mysql database but i dont know the password. Can anyone tell me how to reset the password? The default installation for MySQL is 4.1. Where the exact place or directory for MySQL 5.1? My server install with CentOS 4.1.

Thank you.

[b2bwild]

If you havent setup a root password before.
use this

# mysqladmin -u root password NEWPASSWORD

or this if you want to change or update password

# mysqladmin -u root -p oldpassword newpass

then login

# mysql -u root -p

[signmem]

kill all MySQL Server side process.
ps aux | grep mysql
use command "kill -9 PID" or " service mysqld stop"

then start mysql by hand "mysqld_safe --skip-granttable" <-- I am not sure this option spell correct, you can use mysqld_safe --help try to confirm .


when mysqld_safe --skip-granttable & <--- start you can use command "mysql" login to mysql db as administrator.

update mysql.user set password=password('123') where user='root';
flush privilege;

your password change finish.

[waterhead]

I just installed MySQL on Fedora 10, and I couldn't access the server to set up the password. I finally had to use the "skip-grant-tables" option that signmem mentions. But instead of adding it as an option to the mysql command, I had to add it to the /etc/my.cnf file. It should look like this:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-grant-tables

I was then able to set up the password and start the server. I then removed it from the file.

I found a very helpful online book for MySQL:
MySQL Essentials - Techotopia

[signmem]

never add

old_passwords=1
skip-grant-tables

to my.cnf

it means never load grant-tables <-- it use to define use's permission!!!

after type flush privileges

restart mysqld server.

[waterhead]

never add

old_passwords=1
skip-grant-tables

to my.cnf

it means never load grant-tables <-- it use to define use's permission!!!

I was then able to set up the password and start the server. I then removed it from the file.

If I hadn't performed that little step of adding that to the my.cnf file, I wouldn't be able to use MySQL. So "never" doesn't apply to this problem. Yes, it must be removed after setting the root password for MySQL.