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...
閱讀完整內容

for_python_n_books: else: 那些ptyhon書上沒教事/那些書上沒教的pyhon 12事(123式))

https://medium.com/citycoddee/python%E9%80%B2%E9%9A%8E%E6%8A%80%E5%B7%A7-6-%E8%BF%AD%E4%BB%A3%E9%82%A3%E4%BB%B6%E5%B0%8F%E4%BA%8B-%E6%B7%B1%E5%85%A5%E4%BA%86%E8%A7%A3-iteration-iterable-iterator-iter-getitem-next-fac5b4542cf4  Python 3.6.4 (v3.6.4:d48eceb, Dec 19 2017, 06:54:40) [MSC v.1900 64 bit (AMD64)] on win32 Type "copyright", "credits" or "license()" for more information. >>> h = [1,2,3] >>> print(dir(h)) ['__add__', '__class__', '__contains__', '__delattr__', '__delitem__', '__dir__', '__doc__', '__eq__', '__format__', '__ge__', '__getattribute__', '__getitem__', '__gt__', '__hash__', '__iadd__', '__imul__', '__init__', '__init_subclass__', '__iter__', '__le__', '__len__', '__lt__', '__mul__', '__ne__', '__new__', '__reduce__'...
閱讀完整內容