yum install MySQL-server 安装MYSQL
但是因为某些东东没有安装成功可以先卸载该类库
yum -y remove mysql-libs-5.1.52* -y的意思就是不用询问是否remove
卸载完成之后,再安装MySQL成功了
启动:/etc/init.d/mysql start
登录MYSQL出现问题
mysqladmin: connect to server at ’localhost’ failed
error: ’Access denied for user ’root’@’localhost’ (using password: YES)’
现在终于被我找到了解决方法,如下(请先测试方法三,谢谢!):
方法一:
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>
mysql>
开启远程访问服务:
修改/etc/mysql/my.conf(
/etc/my.cnf),修改bind-address,指定为本机实际IP地址,你的my.conf修改完大概是如下的样子
[mysqld]
#
# * Basic Settings
#
default-character-set=utf8
default-storage-engine=INNODB
bind-address = 192.168.1.xxx
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
2.用root登陆mysql执行如下命令
grant all on systemdb.* to root@’%' identified by ’123456′;
grant all on
systemdb .* to root@localhost identified by ’123456′;
systemdb
替换为你想访问的数据库名,
root 是你的想使用的用户名,123456替换为你的密码,这样就开启了远程访问功能
使用source命令出现乱码,改变字符集:
导入数据库
mysql -uroot -p --default-character-set=gbk
password: ***
use dbname;
source /root/newsdata.sql