ubuntu安装mysql(ubuntu的终端怎么打开)

ubuntu安装mysql

一.首要卸载掉本来的mysql
第一步，顺次执行下面的句子
sudo apt-get autoremove –purge mysql-server
sudo apt-get remove mysql-server
sudo apt-get autoremove mysql-server
sudo apt-get remove mysql-common
第2步 清理残留数据
dpkg -l |grep ^rc|awk ‘{print $2}’ |sudo xargs dpkg -P
二.装置mysql
装置mysql教程
sudo aptitude search mysql
sudo apt install mysql-server
登录mysql
sudo mysql -u root -p
show databases;
use mysql;
show tables;
select host,user from user;
#添加登录账号,答应长途访问’%’
grant all privileges on *.* to ‘admin’@’%’ identified by ‘pass12345xx’ with grant option;
留意：假如报 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘. to ‘admin’@’%” at line 1
提示意思是不能用grant创建用户，mysql8.0曾经的版本能够运用grant在授权的时分隐式的创建用户，8.0以后现已不支持，所以必须先创建用户，然后再授权，指令如下：
CREATE USER ‘admin’@’%’ IDENTIFIED BY ‘pass12345xx’;
grant all privileges on *.* to ‘admin’@’%’;
答应多个IP登录mysql8.0
# 第一个IP
CREATE user ‘admin’@’121.43.128.209’ IDENTIFIED by ‘pass12345xx’;
GRANT ALL on *.* TO ‘admin’@’121.43.128.xxx’;
flush privileges;
# 第二个IP
CREATE user ‘admin’@’139.224.43.133’ IDENTIFIED by ‘pass12345xx’;
GRANT ALL on *.* TO ‘admin’@’139.224.43.xxx’;
flush privileges;
# 有几个IP，就创建多少个用户
修正答应的ip
UPDATE `user` SET `Host`=’172.0.0.1′ WHERE `user`=’admin’ AND `Host`=’175.9.142.131′;
flush privileges;
假如要删除某个IP权限
delete from user where host =’172.0.0.2′;
#刷新
flush privileges;
quit;
#重启
sudo service mysql restart;
#检查mysql版本
mysql -V
第三步 设置MySQL长途访问的权限
aptitude search mysql.conf.d
cd /etc/mysql/mysql.conf.d
ls
#检查目录下所有的文件内容，找到bind-address = 127.0.0.1注释掉
sudo vim mysqld.cnf
加前缀#注释掉bind-address = 127.0.0.1
重启mysql
sudo service mysql restart;
最终从头登录mysql
mysql -u root -p
别的：
修正暗码
update mysql.user set password=password(‘新暗码’) where User=”amdin” ;
mysql检查端口号
show variables like ‘port’;
删除登录用户

ubuntu的终端怎么打开

1、打开ubuntu。
2、然后点击左下角的显示应用程序。
3、进去后找到终端点击就可以了。