phpmyadmin

[kimacc]

I'm trying to set up a guest book on my site is there a tutorial for beginners on how to do this on this site somewhere because im not finding it

[garrettroyce]

I haven't seen one on X10's site. However, if you use Softalicious from your CPanel, it will do all of the work for you. If you don't like any of the scripts in Softalicious, just do a google search for something like "free php mysql guestbook" and if you see one you like, post back here and we can help you install it.

[kimacc]

I think i have one made but im now getting an error of something like cant connect nopassword. I dont want people to have to register to sign the guestbook, anyone can sign.. Im thinking its just because i dont have the localhost part right.. what do i need to change it too.. here is part of my code..

$connect = mysql_connect("localhost","root","") or die ("error");


if i cant figure this out i will try to use the site script, i tryed yesterday but it wouldnt let me go to that page for some reason...

[Gouri]

in your sql connection the username and password has to be changed. On x10 when you creating database you have to create a user and give permission and associate to the perticular database.


place the corresponding username and password in the mysql_connect command.

[kimacc]

how do i go about making the pw and user name if i already created the database??

also can you give me a dummy view of what it would look like on mysql_connect??

[Gouri]

in your control panel select mysal databses , there you can see the created databases and in the down htere is an option to create user, Create one and associate it with corresponding database.

Regarding mysql connect use this way.

DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'Database Name');

DEFINE ('DB_USER', 'Database user');
DEFINE ('DB_PASSWORD', 'Databse Password');

// Make the connnection and then select the database.
$dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to MySQL: ' . mysql_error() );
mysql_select_db (DB_NAME) OR die ('Could not select the database: ' . mysql_error() );

[kimacc]

Error selecting db, i posted what i changed.. Im so close now thanks but im still getting that error...oh and i did make the usernam and password and gave all priviages..

DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'changed_changed'');// I canged this to my db name right??
 
DEFINE ('DB_USER', 'myaccount');//changed
DEFINE ('DB_PASSWORD', 'password123');//changed
 
// Make the connnection and then select the database.
$dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to MySQL: ' . mysql_error() );
mysql_select_db (DB_NAME) OR die ('Could not select the database: ' . mysql_error() );

[Gouri]

Error selecting db, i posted what i changed.. Im so close now thanks but im still getting that error...oh and i did make the usernam and password and gave all priviages..

DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'changed_changed'');// I canged this to my db name right??
 
DEFINE ('DB_USER', 'myaccount');//changed
DEFINE ('DB_PASSWORD', 'password123');//changed
 
// Make the connnection and then select the database.
$dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to MySQL: ' . mysql_error() );
mysql_select_db (DB_NAME) OR die ('Could not select the database: ' . mysql_error() );

One more thing you should remember your db and usernames are always associated with cpanel name

like for example your database name is test the it should be cpanelusername_test and same for dbusername

[kimacc]

thats how i have it set up i think, or do i need to put cpanel, i can post my actual code but i just dont want other people to be able to see it like right now it is kimacc_phpacadamy. or should it be kimacckimacc_phpacadamy???
Edit:
ok i think i know what the problem is it didnt create the username and password, it says "No users associated with this account"

the drop down bocks for users is blank and wont let you type 1 user in... but im think that should be default of 1 anyways
DeleteThere are no users associated with your account.
DeleteThere are no users associated with your account.

[Gouri]

thats how i have it set up i think, or do i need to put cpanel, i can post my actual code but i just dont want other people to be able to see it like right now it is kimacc_phpacadamy. or should it be kimacckimacc_phpacadamy???

Ok

I undestand you are confusing between forum username and cpanel username


I am talking about about the user name where you to login into your cpaenl.

like using http://<yourserver>.x10hosting.com:2082

Then you will give username right that i am talking about.

If i am not wrong then it will be kimacckimacc_phpacadamy In this kimacckimacc is your cpanel username and acadamy is databse name right and also the username willl be kimacckimacc_<username> what ever you created and granted privillages


EDIT:

Your said "oh and i did make the usernam and password and gave all priviages.."

Ok give that username here