通过yum方式安装mysql

1351阅读 3评论2010-11-06 hkebao
分类:LINUX

#yum install mysql

#yum install mysql-server

#yum install mysql-devel
#chgrp -R mysql /var/lib/mysql
#chmod -R 770 /var/lib/mysql

#chkconfig --add mysqld 在服务清单中添加mysql服务

#service mysqld start 服务启动
#mysqladmin -u root password '123456'
更改密码
#mysql -u root -p mysql> DROP DATABASE test;
删除test数据库
#mysql> DELETE FROM mysql.user WHERE user = '';
删除匿名帐户
#mysql> FLUSH PRIVILEGES;
重载权限

#----------开始建立dashboard的账号-----------------

#mysql> CREATE DATABASE dashboard CHARACTER SET utf8;
#mysql> grant all privileges on *.* to dashboard@localhost identified by '123456' with grant option;
#mysql> flush privilegs;

上一篇:puppet里面的exec资源
下一篇:php中的ssh2模块学习[原创]

文章评论