服务器配置安装

服务器

安装mysql(8.0以下版本不建议)

apt install mysql-server  # 安装mysql
# 如果安装过程没有提示设置密码
1、su 
2、service mysql stop
3、service mysql restart
4、mysql -u root -p
5、use mysql;
6、ALTER USER 'root'@'localhost' IDENTIFIED BY '需设置的密码';
# 解决mysql只能以root用户进入且不用验证密码问题
1、sudo mysql -u root -p
2、use mysql；
3、update user set plugin = 'mysql_native_password';
4、flush privileges;
5、mysql -u root -p，输入密码登录成功
# 设置远程登录
1、sudo mysql -uroot -p [你的密码]
2、use mysql
3、select user,host from user；
4、grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
5、flush privileges;
# 设置远程连接
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
bind-address          = 127.0.0.1 将此行注释掉

安装MYSQL8.0以上版本

#命令1 更新源
sudo apt-get update
#命令2 安装mysql服务
sudo apt-get install mysql-server
# 初始化配置
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
# 配置远程访问
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>use mysql;
#查询用户表命令：
mysql>select User,authentication_string,Host from user;
#查看状态
select host,user,plugin from user;
#设置权限与密码 如果无法更改密码使用flush privileges;然后再进行更改密码，修改加密规则操作。
#使用mysql_native_password修改加密规则
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码'; 
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER; #更新一下用户的密码
mysql> UPDATE user SET host = '%' WHERE user = 'root'; #允许远程访问

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

安装Java-JDK

# 更新软件包
sudo apt-get update
# 卸载软件包
sudo apt autoremove 软件包名
# 安装Java JDK：
上传安装包jdk-8u101-linux-x64.tar.gz到目录/opt/softwares中，然后进入目录/opt/softwares，解压jdk-8u101-linux-x64.tar.gz到目录/opt/modules中，解压命令如下：
tar -zxf jdk-8u101-linux-x64.tar.gz -C /opt/modules/
修改文件/etc/profile，配置JDK环境变量：
vi /etc/profile
在文件末尾加入以下内容：
export JAVA_HOME=/opt/modules/jdk1.8.0_144
export PATH=$JAVA_HOME/bin:$PATH
刷新profile文件，使修改生效。
source /etc/profile
# 查看java版本，看看是否安装成功
java -version

端口占用查询

netstat -a  # 查看已经连接的服务端口
netstat -ap  # 查看所有的服务端口
netstat -ap | grep ssh  # 结合grep命令可以查看指定端口
lsof -i   # root查询

服务管理

service 服务名 restart  # 重启服务

卸载MYSQL

首先在终端中查看MySQL的依赖项：dpkg --list|grep mysql
卸载： sudo apt-get remove mysql-common
卸载：sudo apt-get autoremove --purge mysql-server-5.7
清除残留数据：dpkg -l|grep ^rc|awk '{print$2}'|sudo xargs dpkg -P
再次查看MySQL的剩余依赖项：dpkg --list|grep mysql
继续删除剩余依赖项，如：sudo apt-get autoremove --purge mysql-apt-config