CS Notes 301

/*---------------------------------------*/ /* start/stop XAMPP /*---------------------------------------*/ 1. Open Terminal 2. cd /Applications/XAMPP/xamppfiles 3. sudo ./xampp start 4. sudo ./xampp stop ** sudo ./xampp startapache ** sudo ./xampp startmysql  ** sudo /Applications/XAMPP/xamppfiles/xampp start ** sudo /Applications/XAMPP/xamppfiles/xampp status ** sudo /Applications/XAMPP/xamppfiles/xampp help /*---------------------------------------*/ /* mySQL - change root password /*---------------------------------------*/ 1. Open Terminal 2. /Applications/XAMPP/xamppfiles/bin/mysql -u root 3. SET PASSWORD FOR 'root'@'localhost' = PASSWORD('lemonade'); /*---------------------------------------*/ /* mySQL - create new user /*---------------------------------------*/ 1. Open Terminal 2. /Applications/XAMPP/xamppfiles/bin/mysql -u root -p 3. CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; 4. login to phpMyAdmin to assign pri...

MySQL 5.7.6 and later: mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'; ------------------------------ ------------------------------ ------------------------------ - MySQL 5.7.5 and earlier: mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass'); ------------------------------ ------------------------------ ------------------------------ -