Ubuntu 14.04.5 安装 MySQL 5.7
安装
下载地址:https://dev.mysql.com/downloads/mysql/
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-server_5.7.21-1ubuntu14.04_amd64.deb-bundle.tar
tar -xf mysql-server_5.7.21-1ubuntu14.04_amd64.deb-bundle.tar
sudo apt-get update
sudo apt-get upgrade
apt-get install libaio1
sudo dpkg -i mysql-common_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg-preconfigure mysql-community-server_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqlclient20_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqld-dev_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-client_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-client_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-source_5.7.21-1ubuntu14.04_amd64.deb
sudo apt-get -f install
sudo apt-get -f install libmecab2
sudo dpkg -i mysql-community-server_5.7.21-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-server_5.7.20-1u
sudo dpkg -i mysql-server_5.7.21-1ubuntu14.04_amd64.deb
mysql -u root -p
MySQL常用命令
进入MySQL: mysql -u root -p
启动: sudo service mysql start
重启: sudo service mysql restart
关闭: sudo service mysql stop
远程访问
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
- 修改
bind-address: 127.0.0.1
为0.0.0.0
- 新增可远程访问的用户
grant all on *.* to 用户名@'%' identified by '密码' with grant option;
flush privileges;
nodejs
安装git
sudo apt-get install git
安装nvmcurl -o- https://raw.githubusercontent.com/creationix/nvm/v0.33.8/install.sh |bash
source ~/.bashrc
安装nodejsnvm install v8.9.4
其他
https://juejin.im/post/5d07cf13f265da1bd522cfb6
SET PASSWORD FOR ‘root‘@’localhost’ = PASSWORD(‘as2260326’);
update mysql.user set authentication_string=password(‘123qqq…A’) where user=’root’ and host=’localhost’;
ALTER USER ‘root‘@’localhost’ IDENTIFIED BY ‘hu6uY4cCVJf5p6’;
UPDATE mysql.user SET authentication_string = PASSWORD(‘as2260326’)
WHERE User = ‘root’ AND Host = ‘localhost’;
FLUSH PRIVILEGES;
update mysql.user set authentication_string=password(‘as2260326’) where user=’root’ and host=’localhost’;
update user set password=password(‘as2260326’) where user=’root’;
UPDATE mysql.user SET Password=PASSWORD(‘as2260326’)
ALTER USER ‘root‘@’localhost’ IDENTIFIED BY ‘hu6uY4cCVJf5p6’;
SET PASSWORD FOR root = ‘as2260326’