You have to enter the below commands in your mysql.
create database <your_database_name>;
create user <your_database_username>;
create user <your_database_username>@localhost;
set password for <your_database_username> = PASSWORD('<your_database_password>');
set password for <your_database_username>@localhost = PASSWORD('<your_database_password>');
grant all on <your_database_name>.* to '<your_database_username>';
grant all on <your_database_name>.* to '<your_database_username>'@'localhost';
You have to replace <your_database_name>, <your_database_username> and <your_database_password> in above commands with according values.
Normally, the script creates a new database, and then the table structure. However if your server/ISP doesn't give you admin rights to create a new database in MySQL, you will need to contact your server administrator to create the necessary database (or create it yourself). They should create a blank database for you that gives you the appropriate access rights (ie: read/write/create). Start the LimeSurvey installation as usually and it will then create the tables in the existing database.
The mbstring library is a PHP library to be able to convert char sets from one language to another. You need it if you want to run LimeSurvey. To check if it is already installed open the URL
from the web browser. A lot of information will be shown. Search for the string 'mbstring' under the Configuration section.
If you find the mbstring section then all should be well and you can continue on with your LimeSurvey installation!
If you don't find the mbstring section you might have a problem on your hands.
There are three possible scenarios:
This happens if your database itself is not created to use an UTF-8 charset. This can happen when you have to create the database using a provider administration panel. You can fix this problem by executing the following SQL command on your database (using for example phpMyAdmin)
ALTER DATABASE `<your_database_name>` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Replace <your_database_name> with the name of your database. You need to do this before installing LimeSurvey.
The problem is not with the LimeSurvey installation but with the PHP installation.
Sometimes files are not uploaded correctly or were broken during upload. This leads to several different error messages. Most of them refer to a file or function within a file which can't be found.
Solution: Re-upload all files using the binary mode of your FTP program.
This is probably an incorrect setting for $rooturl or $rootdir in config.php. In particular, config.php attempts to set $rootdir correctly by calling dirname('''FILE''') and while this usually works, it can be upset when LimeSurvey is installed in a user's home or public_html directory and the home directory is mounted over NFS. Try setting $rootdir manually, and in particular, while your shell or pwd command may show a path like "/disks/hostname/home/username/public_html/limesurvey", try using "/home/username/public_html/limesurvey".
Warning: fread() [function.fread]: Length parameter must be greater than 0 in /limesurvey/classes/php-gettext/streams.php on line 120
Note: line number may be different depending on your LimeSurvey version.
This may be caused by the mbstring.func_overload setting. Check the setting in your php.ini and set as the following.
mbstring.func_overload = 0
Note: This means no function overloading. See PHP manual for this setting: Function Overloading Feature
Note: Other characters may also induce the same behaviour
Move / rename the limesurvey installation directory so that pathname does not include either the ( or ) characters
For all issues happening after a successful installation please refer to the Troubleshooting page.