Forum Problems Installing LAMS: Re: Error creating database

By: Ernie Ghiglione

[ Reply | Forward ]

Hi Mousam,

What OS are you using?

You need to create the database *before* you try to install LAMS. So login as root into mysql and run:

> SET FOREIGN_KEY_CHECKS=0;
> DROP DATABASE IF EXISTS lams;
> CREATE DATABASE lams DEFAULT CHARACTER SET utf8;
> SET FOREIGN_KEY_CHECKS=1;
> GRANT ALL PRIVILEGES ON *.* TO lams@localhost IDENTIFIED BY 'somepasswordhere';
> REVOKE PROCESS,SUPER ON *.* from lams@localhost;

Then when LAMS prompts for a user and password for MySQL, just enter:

u: lams
p: somepasswordhere

Thanks,

ernie

Posted by Ernie Ghiglione