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')
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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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