阿里云ubuntu 20.04 64位系统,安装java环境和mysql-飞鱼工作室

阿里云ubuntu 20.04 64位系统,安装java环境和mysql

JAVA
1.更新软件包列表:   sudo apt-get update
2.安装openjdk-8-jdk:    sudo apt-get install openjdk-8-jdk -y
3.查看java版本: java -version

 

MYSQL

通过apt 安装MySQL服务(推荐,会安装最新版)
#命令1 更新源
sudo apt-get update
#
命令2 安装mysql服务
sudo apt-get install mysql-server -y

初始化配置
sudo mysql_secure_installation

#1
VALIDATE PASSWORD PLUGIN can be used to test passwords...
Press y|Y for Yes, any other key for No: N (选择N ,不会进行密码的强校验)

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

#3
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 (选择N,不删除匿名用户)

#4
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) : N (选择N,允许root远程连接)

#5
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 (选择N,不删除test数据库)

#6
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 (选择Y,修改权限立即生效)

 

检查mysql服务状态
systemctl status mysql.service

 

 

 

配置远程访问
在Ubuntu下MySQL缺省是只允许本地访问的,使用workbench连接工具是连不上的;
如果你要其他机器也能够访问的话,需要进行配置;

找到 bind-address 修改值为 0.0.0.0(如果需要远程访问)

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf #找到 bind-address 修改值为 0.0.0.0(如果需要远程访问)
sudo /etc/init.d/mysql restart #重启mysql
sudo mysql -uroot -p

mysql的一些必要设置:

#切换数据库
mysql>use mysql;
#查询用户表命令:
mysql>select User,authentication_string,Host from user;
#查看状态
select host,user,plugin from user;

#设置权限与密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码'; #使用mysql_native_password修改加密规则
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER; #更新一下用户的密码
mysql> UPDATE user SET host = '%' WHERE user = 'root'; #允许远程访问

#刷新cache中配置 刷新权限
mysql>flush privileges;
mysql>quit;

查看 mysql 初始的密码策略,

输入语句 SHOW VARIABLES LIKE 'validate_password%'; 进行查看首先需要设置密码的验证强度等级,设置 validate_password.policy 的全局参数为 LOW 即可,
输入设值语句 “ set global validate_password.policy=LOW; ” 进行设值,
当前密码长度为 8 ,如果不介意的话就不用修改了,按照通用的来讲,设置为 6 位的密码,设置 validate_password.length 的全局参数为 6 即可,
输入设值语句 “ set global validate_password.length=6; ” 进行设值,

现在可以为 mysql 设置简单密码了,只要满足六位的长度即可,
输入修改语句 “ ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; ” 可以看到修改成功,表示密码策略修改成功了!!!

 

 

 

修改root用户密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY'mimia';(mysql 8.0.版本适用)
————————————————
版权声明:本文为CSDN博主「1m82」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/h880829/article/details/113807103

RIPRO主题是一个优秀的主题,极致后台体验,无插件,集成会员系统
飞鱼工作室 » 阿里云ubuntu 20.04 64位系统,安装java环境和mysql

提供最优质的资源集合

立即查看 了解详情