MYSQL　５.５.３０安装

最新推荐文章于 2022-09-11 18:29:21 发布

wshxgxiaoli

最新推荐文章于 2022-09-11 18:29:21 发布

阅读量1k

点赞数

分类专栏： MYSQL 文章标签： mysql

本文链接：https://blog.csdn.net/wshxgxiaoli/article/details/16845273

版权

MYSQL 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

所需软件：

cmake-2.8.10.2.tar.gz 
 mysql-5.5.30.tar.gz

安装CMAKE：

tar -zxv -f cmake-2.8.10.2.tar.gz 
cd cmake-2.8.10.2
 ./configure 
make
make install

安装MYSQL

mkdir -p /u01/mysql/data
 groupadd mysql
useradd -r -g mysql mysql
tar -zxvf mysql-5.5.30.tar.gz
cd mysql-5.5.30
cmake -DCMAKE_INSTALL_PREFIX=/u01/mysql -DMYSQL_DATADIR=/u01/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all  -DENABLED_LOCAL_INFILE=1
make
make install

chown -R root:mysql mysql
chown -R mysql:mysql mysql
cd mysql
cp support-files/my-medium.cnf /etc/my.cnf
scripts/mysql_install_db --user=mysql

添加PATH环境变量：

/u01/mysql/bin:/u01/mysql/lib
./bin/mysqld_safe --user=mysql &

将MYSQL设置为自动服务：

 cp support-files/mysql.server /etc/init.d/mysql
 service mysql stop
service mysql start

修改密码：

[root@gd1ebs131 mysql]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.30-log Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql
Database changed
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "vipshop";
update user set password = password('vipshop') where user='root';　
commit;
 flush privileges;

远程连接时报如下错误：
lost connection to mysql server at waiting for initial communication packet

解决办法
修改mysql配置文件

vi /etc/my.cnf

[mysqld]段加skip-name-resolve

重启mysql
service mysql stop
service mysql start