Geoff Partridge - 2017-02-28

One of the main issues I get requests about is not being able to login. This program was designed to work primaly as a webbased program on the internet through cpanel, myphpadmin and my sql. When setting up your database and mysql database user credentials (DB_User, DB_PASSWORD & DB_NAME), these must mirror exactly in the config.php file settings to your MySQL settings or you cannot gain access to your timetable. See below 3 different config.php file configuartion setting examples: (abc and abc123 = your settings like 'DB_USER','john_admin')

Web Server Configuration (internet website)

define('DB_NAME', 'abc_timetable');
define('DB_USER', 'abc_admin');
define('DB_PASSWORD', 'abc123');
define('DB_HOST', 'localhost');

//define('DB_CHARSET', 'utf8');
//define('DB_COLLATE', '');

//define('DEBUG', false);

if ( !defined('ABSPATH') )
define('ABSPATH', dirname(FILE) . '/');

//require_once(ABSPATH . 'settings.php');
?>

XAMPP Server Configuration Version A:

define('DB_NAME', 'timetable');
define('DB_USER', 'admin');
define('DB_PASSWORD', 'abc123');
define('DB_HOST', 'localhost');

//define('DB_CHARSET', 'utf8');
//define('DB_COLLATE', '');

//define('DEBUG', false);

if ( !defined('ABSPATH') )
define('ABSPATH', dirname(FILE) . '/');

//require_once(ABSPATH . 'settings.php');
?>

or

XAMPP Configuration Version B

define('DB_NAME', 'root_timetable');
define('DB_USER', 'root_admin');
define('DB_PASSWORD', 'abc123');
define('DB_HOST', 'localhost');

//define('DB_CHARSET', 'utf8');
//define('DB_COLLATE', '');

//define('DEBUG', false);

if ( !defined('ABSPATH') )
define('ABSPATH', dirname(FILE) . '/');

//require_once(ABSPATH . 'settings.php');
?>

Sometimes for your DB_HOST, you may have a IP number, this depends on your server settings. If all the above configuration settings mirror your MySQL database seetings for DB_User, DB_PASSWORD & DB_NAME, than try using a DB_HOST IP Number instead of LOCALHOST.

 

Last edit: Geoff Partridge 2017-02-28