1.安装包
rpm -ivh MySQL-server-5.1.30-0.glibc23.i386.rpm
报错:说上述包依靠perl-DBI-1.32-5.i386.rpm包,则先安装
rpm -ivh perl-DBI-1.32-5.i386.rpm
如果需要其他包,则相应安装
再安装
rpm -ivh MySQL-server-5.1.30-0.glibc23.i386.rpm (服务器)
rpm -ivh MySQL-client-5.1.30-0.glibc23.i386.rpm (客户端工具)
rpm -ivh MySQL-devel-5.1.30-0.glibc23.i386.rpm (开发用的库及头文件等)
rpm -ivh MySQL-shared-community-5.1.30-0.rhel3.i386.rpm (一些共享库so等)
2.测试
ps -aux | grep mysqld
3.配置
默认情况下,只有本机才能连上root
登入:mysql -uroot -p -hlocalhost
use mysql;
select Host,User from user;
+--------------+------+
| Host | User |
+--------------+------+
| 127.0.0.1 | root |
| localhost | |
| localhost | root |
| rhel4-server | |
| rhel4-server | root |
+--------------+------+
因此,只有本机,root才能登入,从别的机器用root不能登录
注意到User列为空的,代表在本机可以匿名登入,即输入mysql就可以登录
1)更改root密码
use mysql;
update user set password=PASSWORD("new password") Where user='name';
flush privileges;
2)使本机不能匿名登录
use mysql;
delete from user where user='';
flush privileges;
3)其他机器可以用root登录
use mysql;
update user set host='%' where user='root' and host='127.0.0.1';
flush privileges;
或者1),3)也可用以下语句
GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
4.启动、停止
/etc/init.d/mysql start/stop/restart
5.相关目录
/usr/bin mysql相关命令
/usr/lib/mysql mysql相关的库文件*.a
/usr/include/mysql 头文件*.h
/usr/share/mysql 相关配置文件
/usr/sbin mysqld等命令