Fedora MySQL Build

Yum install MySQL yum install mysql-server yum install mysql-devel chgrp-r mysql/var/lib/mysql chmod-r 770/var/lib/mys Ql

Service mysqld Start

Change the root password

mysqladmin-u root password ' newpassword ' Change password

mysql-u root-p Login Database

mysql> DROP DATABASE test; Delete Test Database

mysql> Delete from mysql.user WHERE user = "; Delete Anonymous account

mysql> FLUSH privileges; Overloaded Permissions

add MySQL User: GRANT all privileges on my_db.* to ' user ' @ ' localhost ' identified by ' password ';

# sudo service mysqld restart Restart Services

# sudo service mysqld stop shutdown Services

/etc/rc.d/init.d/mysqld Status View MySQL state

# sudo chkconfig--del mysqld Delete Service list in MySQL service

chkconfig--list See if MySQL is in the auto-launch list

#sudo/etc/init.d/mysqld start MySQL service

#sudo/etc/init.d/mysqld stop to shut down the MySQL service

#sudo/etc/init.d/mysqld Restart restart MySQL service