Forum Problems Installing LAMS: Problem with insert-database

Are you running the Windows installer, the generic Unix/Linux installer or building from source?

Given you mention lams.properties, I assume you are using teh generic Unix/Linux installer.

(1) Is MySQL running on the same server as where you are trying to run the install?

(2) Have you done anything special when you configured MySQL? In  MySQL, you can set it up so that a particular user can only log in from certain servers. Have you changed the root user so that it can only log in from a particular server? This is usually only an issue if MySQL is running on a different database.

(3) Is the username and database name the default values in the lams.properties file (ie lams2) or a different name?

(4) Can you login to MySQL using the database username and password that you have in the lams.properties file? Normally this user is created by the previous step in the build, and I'm wondering if that might have gone wrong. This user is created so that it can only log in from the local machine, so if MySQL is on another server there could be a problem.

Try this, replacing lams2 with whatever you set the username and database name to in your properties file.

$ mysql -u lams2 -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 5.0.27-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use lams2;

Database changed

mysql> exit;

Posted by Fiona Malikoff

Thanks for your reply.

I was checking all your suggestions and I couldn't find a single problem. As a last attempt I checked the my.cnf for any weird settings. I found this part:

# Instead of skip-networking you can listen only on
# localhost which is more compatible and is not less secure.
# bind-address = 127.0.0.1
skip-networking

I simply changed it into:

bind-address = 127.0.0.1
#skip-networking

Now everyting works just fine!

Thanks for your help,

- Piet

Posted by Piet van Soomeren