安装MySQL

1 vi /etc/inittab
3 reboot
5 startx
6 shutdown -h now
7 exit
8 ifconfig
10 top
11 ps -aux | grep ssh
13 ifconfig
17 mount /dev/cdrom /mnt
18 cd /mnt/CentOS/
19 rpm -qa | grep mysql
40 ls *mysql*
41 find / -name "libmysql*" -print
43 ls unixODBC*
44 rpm -ivh unixODBC-2.2.11-7.1.i386.rpm
47 rpm -ivh perl-DBI-1.52-2.el5.i386.rpm
65 rpm -ivh /usr/MySoftware/MySQL-shared-compat-5.0.77-0.rhel5.i386.rpm
66 rpm -ivh perl-DBD-MySQL-3.0007-2.el5.i386.rpm
69 rpm -ivh mysql-5.0.77-3.el5.i386.rpm
77 rpm -ivh mysql-server-5.0.77-3.el5.i386.rpm
82 rpm -qf /usr/lib/libltdl.so.3
84 rpm -ivh libtool-ltdl-1.5.22-6.1.i386.rpm
85 rpm -ivh libtool-1.5.22-6.1.i386.rpm
87 rpm -ivh mysql-connector-odbc-3.51.26r1127-1.el5.i386.rpm
88 rpm -ivh libdbi-dbd-mysql-0.8.1a-1.2.2.i386.rpm
91 service mysqld restart
92 mysql -u root

# /usr/bin/mysqladmin -u root password 123456

# vi /etc/hosts

192.168.1.10 CentOS5

mysql>update user set host = '%' where user = 'root';

mysql>select host, user from user;

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.10' IDENTIFIED BY 'zyx' WITH GRANT OPTION;