mysql在linux下的操作

1、rpm -e mysql //卸载mysql2、yum install -y mysql-server mysql mysql-deve //安装mysql3、rpm -qa|grep mysql //检查是否安装4、show variables like 'character%'; // 查看编码5、chkconfig --list mysqld //检查开机启动状态5、chkconfig mysql on // 开机自动启动修改编码 修改my.ini文件设置编码[client]default-character-set=utf8[mysql]default-character-set=utf8[mysqld]character-set-server=utf8修改root密码/etc/init.d/mysqld stop # mysqld_safe --skip-grant-tables &&，表示在后台运行，不再后台运行的话，就再打开一个终端。# mysqlmysql> use mysql;mysql> UPDATE user SET password=password("***") WHERE user='root'; mysql> flush privileges;mysql> exit;