最牛ubuntu18.10安装mysql

步骤一

在命令行上依次按下以下三条命令

sudo apt install mysql-server
sudo apt install mysql-client
sudo apt install libmysqlclient-dev

步骤三

• 安装设置
  sudo mysql_secure_installation

• VALIDATE PASSWORD PLUGIN can be used to test passwords… Press y|Y for Yes, any other key for No: N (我的选项)

• Please set the password for root here… New password: (输入密码) Re-enter new password: (重复输入)

• By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL without having to have a user account created for them… Remove anonymous users? (Press y|Y for Yes, any other key for No) : N (我的选项)

• Normally, root should only be allowed to connect from ‘localhost’. This ensures that someone cannot guess at the root password from the network… Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y (我的选项)

• By default, MySQL comes with a database named ‘test’ that anyone can access… Remove test database and access to it? (Press y|Y for Yes, any other key for No) : N (我的选项)

• Reloading the privilege tables will ensure that all changes made so far will take effect immediately. Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y (我的选项)

步骤二

• 第一次是不需要密码的

sudo mysql -uroot -p 
update mysql.user set authentication_string=PASSWORD('12345678'), plugin='mysql_native_password' where user='root';
flush privileges

步骤四

Ubuntu上设置MySQL可以远程访问

• 查看MySQL端口允许访问的IP。
  netstat -an|grep 3306
  如果显示为以下内容，则表明只允许本机访问。
  tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN

• 修改/etc/mysql/mysql.conf.d/mysqld.cnf，将里面的bind-address修改成127.0.0.1

bind-address = 127.0.0.1

Ubuntu安装了mysql之后想开启远程,但是远程怎么都登陆不上

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;
flush privileges;

重启mysql
service mysql restart
Ubuntu重启mysql直接用mysql就可以