安装和升级mysql命令

rm -fr /stage

rm -fr /labs/

cd Desktop/

./setup.sh

cd

cd /opt

Pwd

tar xf /stage/MySQL-Server/mysql-advanced-5.7*.tar.gz

ln -s /opt/mysql* /usr/local1/mysql

ln -s /opt/mysql* /usr/local/mysql

ls /usr/local/mysql/bin

cd

pwd

ls -a

vi .bashrc

cp /labs/my.cnf /etc/my.cnf

y

adduser -r mysql

mysql --initialize

source .bashrc

mysqld--initialize

换窗口

mkdir /var/run/mysqld

chown mysql:mysql /var/run/mysqld/

mysqld_safe &

换窗口

mysql -uroot -p

use mysql

ALTER USER USER() IDENTIFIED BY 'oracle';

show databases;

use mysql

show tables；

换窗口

pgrep -lf mysqld

mysqladmin -uroot -p shutdown

pgrep -lf mysqld

cat /labs/service-5.7/mysqld.service

cp /labs/service-5.7/mysqld.service \

/usr/lib/systemd/system

systemctl enable mysqld.service

systemctl start mysqld

pgrep -lf mysqld

mysql -uroot -p

Exit

cd /stage/MySQL-Shell

Ls

mysqlsh root@localhost --util checkForServerUpgrade

systemctl stop mysqld

systemctl status mysqld

cd /opt

tar xf /stage/MySQL-Server/mysql-commercial-8*.tar.gz

ls /opt

ll /opt

rm /usr/local/mysql

y

ln -s /opt/mysql-commercial-8* /usr/local/mysql

ls /usr/local/mysql

ls -l /usr/local/mysql

cp /labs/service-8.0/mysqld.service \

/usr/lib/systemd/system

y

systemctl daemon-reload

systemctl start mysqld

systemctl status mysqld

systemctl status mysqld -l

mysql --version