CodeIgniter: Unable to connect to your database server using the provided settings Error Message

I think, there is something wrong with PHP configration. First, debug your database connection using this script at the end of ./config/database.php : … … … echo ‘<pre>’; print_r($db[‘default’]); echo ‘</pre>’; echo ‘Connecting to database: ‘ .$db[‘default’][‘database’]; $dbh=mysql_connect ( $db[‘default’][‘hostname’], $db[‘default’][‘username’], $db[‘default’][‘password’]) or die(‘Cannot connect to the database because: ‘ . mysql_error()); mysql_select_db ($db[‘default’][‘database’]); echo …

Read more

How to find out the username and password for mysql database

Go to this file in: WampFolder\apps\phpmyadmin[phpmyadmin version]\ Usually wamp is in your main hard drive folder C:\wamp\ You will see something like: $cfg[‘Servers’][$i][‘user’] = ‘YOUR USER NAME IS HERE’; $cfg[‘Servers’][$i][‘password’] = ‘AND YOU PASSWORD IS HERE’; Try using the password and username that you have on that file.

results grid not showing on mysql workbench 6.3.9 for macOS sierra

Good News! 😃 Apparently this is a widespread bug on macOS High Sierra that was fixed in version 6.3.10 that was released Nov. 15th 2017. They fixed it as described in the release notes: Executing a query in MySQL Workbench on a host running macOS High Sierra failed to load the result grid completely, …

Read more