• Registered: 07/02/2012
  • Posts: 4

Topic: Installation issues

I am using EasyPHP v5.3.9
Windows 2008 64bit
FrontAccounting v2.3.11
Stuck at the second Installation wizard screen
Server host: localhost
Database User: root
Password: Don't know
Database Name: Project-1
Use '0_' Table Prefix: Yes
Install Additional Language Packs from FA Repository: nothing selected
Install Additional COAs from FA Repository: nothing selected

I don't know what the password is and I can't seem to progress any further.

Any help would be greatly appreciated!

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: Installation issues

This is the password for the user on the MySql server. Check the MySql for the password.

/Joe

  • Registered: 07/02/2012
  • Posts: 4

Re: Installation issues

Hi Joe,

What I have figured out is that the password to mysql is "mysql", from the mysql configuration file. It still does not work. I may be looking in the wrong place.
The error message on the top of the installation screen reads:

"Cannot connect to database. User or password is invalid or you have no permittions to create database."

Thanks
Rez

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: Installation issues

Go to your installation of the phpMyAdmin. Look for the config.inc.php file and look after

$cfg['Servers'][$i]['user'] = 'YOUR USER NAME IS HERE'; 
$cfg['Servers'][$i]['password'] = 'AND YOU PASSWORD IS HERE';

or do the following:

Stop the MySQL process.

Start the MySQL process with the --skip-grant-tables option.

Start the MySQL console client with the -u root option.
 
List all the users;
SELECT * FROM mysql.user; 

 Reset password;
UPDATE mysql.user SET Password=PASSWORD('[password]') WHERE User='[username]'; 

--------------------------------------------------------------------------------

 But DO NOT FORGET to


Stop the MySQL process 

Start the MySQL Process normally (i.e. without the --skip-grant-tables option)
 
when you are finished. Otherwise, your database's security could be compromised.

Joe

  • Registered: 07/02/2012
  • Posts: 4

Re: Installation issues

Thanks Joe!

I got locked out of SQL then reversed my settings and back to square one. However, since then my colleague disabled the firewall and it is working and it's installed. I would have never thought.