MySQL

Connect to MySQL database locally

mysql -uroot -pPHfaaGe7769ll

Check the location path for shared library and plugins

mysql>show variables like 'plugin_dir';
#OR
mysql>select @@plugin_dir
#OR
SHOW VARIABLES WHERE Variable_Name LIKE "%dir";

Connect remotely

mysql -u root -p'root' -H 192.168.230.55

Other elements to check for

Last updated