Mysql On Mac
there are some differences that you need to know and I would like summarise in this page
Installation
after that you install the pkg you will find all the files in this directory
/usr/local/mysql
in the bin subdir there are all the commands
Reset the password
thanks to the website https://coolestguidesontheplanet.com
the automatic password created during the installation will expire soon , you need to login using the mysql command line and change
/usr/local/mysql/bin/mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.17
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
Query OK, 0 rows affected (0.01 sec)
Root Password Lost
sudo /usr/local/mysql/support-files/mysql.server stop
sudo /usr/local/mysql/support-files/mysql.server start --skip-grant-tables
/usr/local/mysql/support-files/mysql
mysql> FLUSH PRIVILEGES;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
Ctrl + z
sudo /usr/local/mysql/support-files/mysql.server start
/usr/local/mysql/support-files/mysql -u root -p
enter the new password i.e MyNewPass
Start the service
sudo /usr/local/mysql/support-files/mysql.server start
sudo /usr/local/mysql/support-files/mysql.server stop
sudo /usr/local/mysql/support-files/mysql.server restart
Realy nice Mysql Client for mac
versione della pagina: 3, ultima modifica: 05 Sep 2018 20:14