CentOS5.5下安装MySQL 5.5笔记(二)
chown -R mysql .
[root@localhost mysql]# chgrp -R mysql .
[root@localhost mysql]# scripts/mysql_install_db --user=mysql
初始化
数据库
[root@localhost mysql]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
安全启动mysql
[root@localhost mysql]# ./bin/mysqld_safe --user=mysql
关闭mysql
[root@localhost mysql]# ./bin/mysqladmin -u root shutdown -p
默认密码为空
方便调用，为mysql设置一个软链接
[root@localhost ~]# ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
www.2cto.com
其他设置处理：
设置选项文件，将配置文件拷贝到/etc下
[root@localhost mysql]# cp support-files/my-medium.cnf /etc/mysql.cnf
设置开机自启动
[root@localhost mysql]# cp support-files/mysql.server /etc/init.d/mysql
[root@localhost mysql]# chmod +x /etc/init.d/mysql
[root@localhost mysql]# chkconfig –add mysqld
[root@localhost mysql]# chkconfg mysqld on
现在可以通过服务来启动和关闭Mysql服务器
[root@localhost ~]# service mysql start
[root@localhost ~]# service mysql shutdown
连接服务器
[root@localhost ~]# mysql -u root -pyourpassword
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.5.27 Source distributino
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> ... www.2cto.com
mysql> 提示符告诉你mysql准备为你输入命令。
至此MySQL已经正常安装并可以使用
mysql> QUIT
以上参考网址：
http://www.2cto.com/database/201209/156148.
html；
http://www.2cto.com/database/201209/156150.html.
后面对于MySQL的应用可参考MySQL5.5参考手册。