Linux下安装MySQL5.x

Linux下的mysql卸载

编译安装的Mysql直接删除安装目录就可以了，例如
# cd /usr/local
# rm -rf mysql

rpm安装的mysql也要用rpm卸载，步骤如下：
#rpm -qa |grep -i mysql    //找到系统中的Mysql版本，如果是系统自带的Mysql则是rpm -qa |grep mysql  

进入Mysql

Linux下的mysql命令和Windows下一样，进入时的命令：
# /usr/local/mysql/bin/mysql -u root -p    // /usr/local/mysql/是其安装目录

修改root密码
修改密码命令：mysqladmin -u用户名 -p旧密码  password 新密码
比如原root密码为空，新密码为"ab12"

# bin/mysqladmin -uroot -password ab12
再次改密码为"cde345"
# # bin/mysqladmin -uroot -pab12 password cde345

添加远程访问权限
添加远程权限：grant all privileges on *.* to username@'%' identified by 'passwd' with grant option;
# bin/mysql -uroot -p  //根据系统提示输入正确password
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 135 to server version: 5.0.22-standard-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql;
mysql> grant all privileges on *.* to root@'%' identified by 'cde345' with grant option;
mysql> flush privileges;