Forget-password-of-mysql

 #/etc/rc.d/init.d/mysqld stop

#/usr/bin/mysqld_safe --skip-grant-tables &

即可不需密碼進入 Mysql

留言

張貼留言

這個網誌中的熱門文章

rsyslog

  vi /etc/rsyslog.d/50-default.conf 增加一行 auth,authpriv.*     (client ip) sudo systemctl restart rsyslog 可以下指令查看514是否有監聽中。 ss -tunelp | grep 514
閱讀完整內容

mysqldump備份資料庫檔案

新版mysqldump預設會使用UTF8，不用指定default-character-set 備份資料庫 #mysqldump -h localhost -usqmc sqmctest > sqmctest.sql; [root@Srv ECC-SQMC]# mysql-usqmc -p  > drop database sqmc; > create  database sqmc; > grant .... [root@Srv ECC-SQMC]# mysqldump -usqmc -p sqmc  Enter password: -- MySQL dump 10.13  Distrib 8.0.21, for Linux (x86_64) -- -- Host: localhost    Database: sqmc -- ------------------------------------------------------ -- Server version       8.0.21 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL...
閱讀完整內容

using-dvd-iso-to-update-yum-centos-8

mount -t iso9660 -o loop ~wkh/CentOS-Stream-8-x86_64-20201030-dvd1.iso /media/CentOS/ cd /etc/yum.repos.d/ vi CentOS-Stream-Media.repo ----- # CentOS-Stream-Media.repo # # You can use this repo to install items directly off the installation media. # Verify your mount point matches one of the below file:// paths. [media-baseos] name=CentOS Stream $releasever - Media - BaseOS baseurl=file:///media/CentOS/BaseOS #        file:///media/cdrom/BaseOS #        file:///media/cdrecorder/BaseOS gpgcheck=1 enabled=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial [media-appstream] name=CentOS Stream $releasever - Media - AppStream baseurl=file:///media/CentOS/AppStream #        file:///media/cdrom/AppStream #        file:///media/cdrecorder/AppStream gpgcheck=1 enabled=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial #ln -s /run/media/wkh/CentOS-Stream-8-x86_64-dvd /media/CentOS 更改到其他mirror版本時，執行以下...
閱讀完整內容