SQL Details

[Umm 'Uthmaan]

Assalaamu Alaikum,
I have downloaded a freebie search function [iSearch] for my site-to-be, and the configuration page is asking for the following details:

/* Fill in the following as applicable for your MySQL configuration. If you
* do not know what to put here, please contact your hosting service provider.
*/
$isearch_sql_server = "localhost";
$isearch_sql_username = "mysql_user";
$isearch_sql_password = "mysql_password";
$isearch_sql_database = "mysql_database";

Would this info be somewhere in the CPanel? I couldn't find anything on it.

wa-salaam,
Umm 'Uthmaan.

[sajid]

Salams

what ya need to do is Create a Database First of all

login to Cpanel

Then...Go to the Mysql databases

then add a database call it whatever u like

then u need to Add a Username and assign in a password

then u need to Assign That particular username to the database u created

Its all there quite simple to do

Then for the detail u put in the following:

$isearch_sql_server = "localhost"; ((this remains the same)
$isearch_sql_username = "mysql_user"; ((this is the Username that u created ))
$isearch_sql_password = "mysql_password"; (password)
$isearch_sql_database = "mysql_database"; ( database name it will have a prefix of your cpanel login name followed by database name..example if ur cpanel login name was mywebsite and u created a database called thisdatabase the DB will be called mywebsite_database)

That shud work!

let me know how it goes :)

ws
sajid

[Umm 'Uthmaan]

I did that and then went to mysite.com/isearch/admin and typed in my password, but it keeps saying that it can't connect to the database. Something about the configuration. I created the database and username with password, added the details to the configuration page, but is there supposed to be something in the database?

wa-salaam,
Umm 'Uthmaan.

[sajid]

Salams

hmm...i think its probably asking for a master admin login Password

The Database password and all are Probably Seperate and its kept for database connection

this new admin password is the password that u will use to login to your admin panel which is totally different..

if u pm / email me the details and all i can have a look at it if u wnat?

sajid

[ramadan]

Salam

I was using mysql for one year, i was using the Konsole(black screen). I always thought that phpmyadmin that comes with the cpanel will be easier. Unfortunally for one week i'm trying to make the basic connection.
Is it any way to create the database and tables manually. It will be easier for me.
Jazaka'allah

[sajid]

Salams

u can create DB manually via..Cpanel..

to create Tables.....hmm never tried it to be honest wid u.....but i think u can run SQL queries via PHPmyadmin....adn create tables that way..try it like that

sajid

[ramadan]

I'll try
jazaka'allah