How set MYSQL ?

[vitoto]

Hi, we try upload free script but nor know how set mysql user and password, any can help me ?

Thank you.

 

[vishal]

You can create database and database user from Cpanel.

 

[Gouri]

Hi, we try upload free script but nor know how set mysql user and password, any can help me ?

Thank you.

Create the database in cpanel --> mysql databases and create a user for database then assign all the privileges to that user

Set those settings here at the scripts config file.

database host is localhost
databasename is cpanelusername_databasename
username is cpanelusername_databaseusername

 

[vitoto]

Is not working, i am create DB in phpmyadmin and set user/pwd.

After move files the "expense-report-software" and run .SQL file in phpmyadmin

SQL Finishing ok and make 6 tables.

But when ejecute my site : http://vitoto.x10hosting.com/

Get error : CDatabase::Connect() error

System use : site.xml

and parameters is :

<database type="mysql">
<server>localhost</server>
<login>same user used in phpmyadmin</login>
<password>same pwd used in phpmyadmin</password>
<default>vitoto.expense</default>
</database>

Any idea ?

Readme is very simple :
http://vitoto.x10hosting.com/readme.htm

 

[satubis arkon]

The database name must be like this: "yourname_databasename" and the user to the database "yourname_username". I hope you understand. You can try to see if the script that you have uploaded is correctly linking to the database and haves the proper user and password.

 

[vitoto]

The database name must be like this: "yourname_databasename" and the user to the database "yourname_username". I hope you understand. You can try to see if the script that you have uploaded is correctly linking to the database and haves the proper user and password.

Data was change to :

<database type="mysql">
<server>localhost</server>
<login>vitoto_vitoto0</login>
<password>same pwd used in phpmyadmin</password>
<default>vitoto_expense</default>
</database>

Is not working.

 

[satubis arkon]

Data was change to :

<database type="mysql">
<server>localhost</server>
<login>vitoto_vitoto0</login>
<password>same pwd used in phpmyadmin</password>
<default>vitoto_expense</default>
</database>

Is not working.

Did you set the vitoto_vitoto0 user "all privileges" to the vitoto_expense database?
and at the password is not the password used in phpmyadmin, is the password you have set for the user vitoto_vitoto0. I hope you get it stright. Tell me the result after you test this.

 

[vitoto]

<password>same pwd used in phpmyadmin</password>

Yes, password is password setting for phpmyadmin when create vitoto_expense in wizard.

vitoto_vitoto0 have all privileges, remember wizard ask for privileges the user created.

 

[satubis arkon]

Create another database, but don`t use the wizard, make it manual. Here are the steps:
1 Go to mysql@database (the first one in the left)

2 At "New Database: vietoto_" write the name of the database and create it

3 scroll down at "MySQL Users Add New User" and write the name of the user and it`s password (ex:abcd) and create the user

4 At the bottom you will find "Add User To Database" select the mysql user and the database and click add. You will be asked to set the privileages of the user to the database, check the all priveleages option and submit your request.

5 At the script use this settings:
host: localhost
database: vitoto_databasename
user: vitoto_username
password: the password set to the vitoto_username, in my example (abcd)

you can find a video tutorial here: http://www.cpanel.net/media/tutorials/addmysql.htm
I wait for your reply to see if you manage to do this straight. If you do all this things as i said your site will have to work, otherwise the problem is somewhere in the script

 

[vitoto]

hi, is not working.

you can help using little your time and download apps and try install ?
http://expense-report-software.org/expense-report-download.php

Script is very very small and simple, not have more the 10 mins the you time.

Please, thank you again.

 

[satubis arkon]

I have maked the script to link to the database but i don`t get anything from it, i can`t login...i think the script is not good.
search on google for "wamp server" and download it. Install it on your pc and you will have a webserver on it. put the script in the "www" directory (don`t overwrite the index.php, put the script in a diferent directory). After that type "localhost" in your browser and you will access the pc webserver, test there the script. you have to make a new mysql database (make it`s name "hopa") and import "site.sql" in it, after that you will have to modify the "site.xml" using notepad. modify the <database type="mysql">
etc etc etc
</database>

with
<database type="mysql">
<server>localhost</server>
<login>root</login>
<password></password>
<default>hopa</default>
</database>

this will make the script work, but you will can not login...i don`t know why
my opinion is to search for another script...

 

[vitoto]

Thank you. for you time.