ubuntu17安装mysql后数据库乱码_ubuntu16.04源码安装mysql-8.0.17

使用wget下载

1.安装依赖

sudo apt-get install gcc g++ make cmake libssl-dev libncurses5-dev pkg-config -y

2.cmake、make、make install出错时

make clean

sudo rm CMakeCache.txt

3.编译很耗内存，至少1G，需要增加交换空间，机器好的可以忽略这一步

sudo dd if=/dev/zero of=/swapfile bs=1M count=2048

sudo mkswap /swapfile

sudo swapon /swapfile

sudo swapon -s

增加了还是不够时

sudo swapoff -a

再次执行上面的命令

4.添加用户组、文件夹以及权限

sudo groupadd mysql

sudo useradd -g mysql mysql

sudo mkdir -p /usr/local/mysql/data

sudo chown -R mysql:mysql /usr/local/mysql

5.进入mysql源码目录再创建build目录，然后进入build目录(make的时候会产生很多文件及文件夹目录)

cmake .. -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DWITH_BOOST=/home/vagrant/src/mysql-8.0.17/boost -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_SSL=system -DFORCE_INSOURCE_BUILD=1 && make && sudo make install

6.初始化mysql生成root账号密码

/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

7.把mysqld放到/etc/init.d/下，方便使用

sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

sudo chmod +x /etc/init.d/mysqld

sudo vim /etc/init.d/mysqld

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

sudo update-rc.d mysqld defaults

sudo service mysqld start

ps -ef | grep mysqld

8.登录mysql

export PATH=$PATH:/usr/local/mysql/bin

mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';

如 ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

make的时候会非常慢，耐心等待！