<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Installation issues]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=3182&amp;type=atom" />
	<updated>2012-07-05T06:33:46Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=3182</id>
		<entry>
			<title type="html"><![CDATA[Re: Installation issues]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=12845#p12845" />
			<content type="html"><![CDATA[<p>Thanks Joe!</p><p>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&#039;s installed. I would have never thought.</p>]]></content>
			<author>
				<name><![CDATA[creatait]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=14566</uri>
			</author>
			<updated>2012-07-05T06:33:46Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=12845#p12845</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Installation issues]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=12839#p12839" />
			<content type="html"><![CDATA[<p>Go to your installation of the phpMyAdmin. Look for the config.inc.php file and look after<br /></p><div class="codebox"><pre><code>$cfg[&#039;Servers&#039;][$i][&#039;user&#039;] = &#039;YOUR USER NAME IS HERE&#039;; 
$cfg[&#039;Servers&#039;][$i][&#039;password&#039;] = &#039;AND YOU PASSWORD IS HERE&#039;; </code></pre></div><p>or do the following:</p><div class="codebox"><pre><code>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(&#039;[password]&#039;) WHERE User=&#039;[username]&#039;; 

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

 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&#039;s security could be compromised.</code></pre></div><p>Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2012-07-04T06:44:14Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=12839#p12839</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Installation issues]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=12838#p12838" />
			<content type="html"><![CDATA[<p>Hi Joe,</p><p>What I have figured out is that the password to mysql is &quot;mysql&quot;, from the mysql configuration file. It still does not work. I may be looking in the wrong place.<br />The error message on the top of the installation screen reads:</p><p>&quot;Cannot connect to database. User or password is invalid or you have no permittions to create database.&quot;</p><p>Thanks<br />Rez</p>]]></content>
			<author>
				<name><![CDATA[creatait]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=14566</uri>
			</author>
			<updated>2012-07-04T06:18:14Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=12838#p12838</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Installation issues]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=12836#p12836" />
			<content type="html"><![CDATA[<p>This is the password for the user on the MySql server. Check the MySql for the password. </p><p>/Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2012-07-04T05:39:23Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=12836#p12836</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Installation issues]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=12834#p12834" />
			<content type="html"><![CDATA[<p>I am using EasyPHP v5.3.9<br />Windows 2008 64bit<br />FrontAccounting v2.3.11<br />Stuck at the second Installation wizard screen<br />Server host: localhost<br />Database User: root<br />Password: Don&#039;t know<br />Database Name: Project-1<br />Use &#039;0_&#039; Table Prefix: Yes<br />Install Additional Language Packs from FA Repository: nothing selected<br />Install Additional COAs from FA Repository: nothing selected</p><p>I don&#039;t know what the password is and I can&#039;t seem to progress any further. </p><p>Any help would be greatly appreciated!</p>]]></content>
			<author>
				<name><![CDATA[creatait]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=14566</uri>
			</author>
			<updated>2012-07-04T04:25:03Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=12834#p12834</id>
		</entry>
</feed>
