Install and configure mysql5.0 in rpm

MySql installation during rpm installation and configuration of mysql5.0: first check whether: rpm-qa | grep mysql -- both check rpm-qa | grep MySQL. If installation is successful, delete: rpm-e ****** 1. Before installation, prepare mkdir usr/mysql cd to enter the Directory and upload the installation package to the/usr/mysql directory. 2. Install: rpm-ivh MySQL-server-5.0.16-0.i386.rpm rpm-ivh MySQL-elient-5.0.16-0.i386.rpm3, verify installation is successful: rpm-qa | grep mySQL start mysql method: 1, service mysql start2,/etc/rc. d/init. d/mysql start installation directory:/usr/mysql database Directory:/var/lib/mysql configuration file directory:/usr/share/mysql related commands: /usr/bin/script at startup:/etc/rc. d/init. d/set the password:/usr/share/mysqladmin-u root password '000000' # MySQL-u-root-p> show databases;> use mysql;> show tables;> quit; --------------- When you exit from the database: update MySQL set host = '%' where host = 'localhost' grant all privileges on *. * to root @ "%" flush privileges common mysql commands: 1. Restart the mysql service: # server mysql restart2. Check whether mysql is installed: # rpm-qa | grep mysql3. uninstall mysql: # rpm-e mysql-server; # rpm-e mysql-client4, other commands: # mysqladmin version; # mysqladmin status;