分類: MySQL-MariaDB

更改資料庫文件匣

EXEC master.dbo.sp_addlinkedserver @server = N’MYSQL’, @srvproduct=N’MySQL’, @provider=N’MSDASQL’, @provstr=N’DRIVER={MySQL ODBC 5.2 Unicode Driver}; SERVER=127.0.0.1; DATABASE=stone; USER=uuu; PASSWORD=ppp; OPTION=3′

參考文章 http://www.dotblogs.com.tw/rainmaker/archive/2012/12/26/86009.aspx

輸入指令(讓使用者從任何主機連接到mysql or MariaDB伺服器)

mysql -u root -p"youpassword" 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit;
MySql 8.0==================================================
回復傳統密碼規則
[mysqld]
default-authentication-plugin=mysql_native_password

CREATE USER 'admin3'@'%' IDENTIFIED BY 'password';
GRANT ALL ON *.* TO 'admin3'@'%';
FLUSH PRIVILEGES;
每行結尾為[；]分號
這樣就能遠端連線了。
[註]有時候必須先修改 root 密碼
#ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
啟動日誌檔=================================================
https://www.jianshu.com/p/db19a1d384bc