CS Notes 301

 If you found error "wrong permissions on configuration file, should not be world writable!" when call phpMyAdmin page (localhost), please change file "phpMyAdmin/config.inc.php" permission. Ex. sudo chmod 755 / your_directory /phpmyadmin/config.inc.php

/*---------------------------------------*/ /* 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...

phpmyadmin \ config.inc.php /* Authentication type */ $cfg['Servers'][$i]['verbose'] = 'mysql wampserver'; $cfg['Servers'][$i]['auth_ type'] = 'cookie'; //$cfg['Servers'][$i]['auth_ type'] = 'config'; //$cfg['Servers'][$i]['user'] = 'root'; //$cfg['Servers'][$i][' password'] = ''; /* Server parameters */ $cfg['Servers'][$i]['host'] = '127.0.0.1'; $cfg['Servers'][$i]['connect_ type'] = 'tcp'; $cfg['Servers'][$i]['compress' ] = false; /* Select mysql if your server does not have mysqli */ $cfg['Servers'][$i][' extension'] = 'mysqli'; $cfg['Servers'][$i][' AllowNoPassword'] = false;