全部博文(2065)
分类: LINUX
2010-11-06 09:37:34
#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;