Category: mysql

vim /etc/my.cnf [client] #password = your_password port = 3307 socket = /tmp/mysql.sock systemctl restart rc-local.service vim frpc.ini [mysql] type = tcp local_ip = 10.168.1.115 local_port = 3306 remote_port = 3307 custom_domains = 39.100.102.12 systemctl restart frpc.service root135@root135:~/Desktop$ mysql -u root -p -h 39.100.102.12 -P 3307 Enter password: Welcome to the MariaDB monitor. Commands end with… Continue reading mysql 远程端口3307

mysql> update user set password=password(‘123456′) where user=’root’ and host=’root’ or host=’localhost’; Query OK, 2 rows affected (0.00 sec) Rows matched: 2 Changed: 2 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> update mysql.user set host=’10.168.1.115′ where user=’root’ and host=’localhost’; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed:… Continue reading mysql update delete