hushui的专栏

mysql DB file imigration/maintainment D:\git-yl\Win\mysql-5.5.60-winx64\bin>mysql_upgrade.exe -u root -p Enter password: ****** Looking for 'mysql.exe' as: D:\git-yl\Win\mysql-5.5.60-winx64\bin\mysql.exe Looking for 'mysqlcheck.exe' as: D:\git-y...

#mysql-5.7.28-winx64 hushui@Hushui MINGW64 /d/git-yl/Win/mysql-5.7.28-winx64 $ ls -l bin/ total 423216 -rwxr-xr-x 1 hushui 197121 15656 9月 27 2019 echo.exe* -rwxr-xr-x 1 hushui 197121 5471544 9月 27 2019 innochecksum.exe* -rwxr-xr-x 1 hushui 197...

1.gogs_0.11.91_linux_amd64.tar.gz hushui@Hushui:/mnt/d/gogs$ scp gogs_0.11.91_linux_amd64.tar.gz git@47.100.203.63:/home/git/ git@47.100.203.63's password: gogs_0.11.91_linux_amd64.tar.gz 100% ...

[lake@izuf6ad1jbc6ftdqtbuiquz opt]$ mysql -bash: mysql: command not found [lake@izuf6ad1jbc6ftdqtbuiquz opt]$ rpm -qa |grep mar mariadb-libs-5.5.56-2.el7.x86_64 [lake@izuf6ad1jbc6ftdqtbuiquz opt]$ rpm -qa |grep mysql [lake@izuf6ad1jbc6ftdqtbuiquz opt]$...

### MySQL 5.7.28 Community Server Centos7 [lake@localhost opt]$ netstat -an --tcp |grep 3306 tcp6 0 0 :::3306 :::* LISTEN [lake@localhost opt]$ systemctl status mysqld ● mysqld.service - MySQL Server ...

1. MySQL 5.7.28 Community Server Centos7 [lake@localhost opt]$ netstat -an --tcp |grep 3306 tcp6 0 0 :::3306 :::* LISTEN [lake@localhost opt]$ systemctl status mysqld ● mysqld.service - MySQL Server...

lake@localhost:~$ mysql -u root -p Enter password:  Welcome to the MariaDB monitor.  Commands end with ; or \g. Your MariaDB connection id is 26 Server version: 5.5.44-MariaDB MariaDB Server Copyrigh...

### create user  MariaDB [(none)]> create user 'training'@'localhost' identified by '123456'; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> flush privileges; Query OK, 0 rows affected ...