Help! Newbie.. Local server script execution

donfray

$dhost = "localhost"; //usually localhost, or ip
$dusername = "name"; // database user
$dpassword = "pass"; // database pass
$ddatabase = "script"; // database name
$script_path = "http://localhost/script

The above are the details that one of my main configuration files ask for the script execution. Though I am connected to the internet, I am just testing this script on my computer's local server (I use Xampp).

I created the database (I'm not sure if its the proper way to create), logged in to phpmyadmin >> create database and created a database. I haven't changed anything after the database creation.

Can you explain the above lines of code? I gave the username as root and no password for it so left it blank. Can someone help me with this?
What is the script path I should give for running the script on the local server.

Thanks

efficacious

$dhost - is the domain name of your server
(either: localhost, your {outside} ip ex. 240.45.56.52, or your domain name ex. yoursite.com)

$dusername - is the username required by your database for logging in.
(usually 'admin' if unchanged)

$dpassword - is the password required by your database for logging in.
(usually 'root' or 'password' if unchanged)

$ddatabase - is the NAME of the database in your database
(sounds confusing i kno)

example...
Your database is 'MySQL'
Your Mysql Database is 'myDatabase'

$script_path - is the path where your root folder is on your WEB server that your php scripts will be running in.

example....
http://www.yoursite.com/ points to c:\WebServer\wwwroot\

if your php scripts are inside a folder called 'Scripts' in your WEB server

your 'script path' would be "/Scripts/"

on your systems directory file system it would be
c:\WebServer\wwwroot\Scripts

hope that helps🙂

donfray

What path should I give?
The script is currently in my E:/script/scriptname
Could you help me out with this please? I'm a bit confused.

And, in xampp the username is root, and there is not password for my database.
How do I add/change username & passwords for the new databases created?

efficacious

is this location on the websever?

E:/script/scriptname

you have to run the php files through the webserver.. have to..
php works by utilizing browser,SQL server, webserver, and the php engine.

so your scripts should be in a folder within your webroot folder

with apache this would the 'htdocs' folder

with windows IIS it would be the 'wwwroot' folder.

making the file path to your scripts:

c:\server\htdocs\Scripts

and your 'Script Path'

http://www.yoursite.com/Scripts/

HOWEVER!

the 'http://www.yoursite.com' part is usually a given when talking about script paths.. so

you would just enter :

'/Scripts/'

for your script path.

assuming your using the MySQL database you can change the database permission by typing this into the SQL command line as a query.

first:

USE DATABASE yourdatabase;

then:

GRANT ALL PRIVILEDGES ON yourdatabase.* TO 'username'@'localhost' IDENTIFIED BY 'password'

obviously we would replace 'yourdatabase' with the name of the database you created for yourself. as well replace username and password with an actual username and password.

donfray

This is what I gave. I transferred all the files to the xampp\htdocs\ folder.

$dhost = "localhost"; //usually localhost, or ip
$dusername = "root"; // database user
$dpassword = ""; // database pass
$ddatabase = "demo"; // database name
$script_path = "http://localhost/script"

But again, there is an error;

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in C:\xampp\htdocs\scriptbuxnew\install\config.php on line 30
Error connecting to MySQL server: Access denied for user 'root'@'localhost' (using password: NO)

What should I do?

efficacious

create a password..

the password will only need to be used in code to connect to the database.
it won't hurt anything to use one.

i don't know how you could not use a password i've always given one.

donfray

i am not sure as to how to create the password, the method that you mentioned above doesn't seem to work for me...

efficacious

thats the only way i kno of to set the password besides setting the root password..

with the GRANT ALL statement your giving permissions just to that database
i know the statement and i have to enter it a few times cuz i always end up typing it incorrectly

are you running this in the command line??

GRANT ALL PRIVILEGES ON yourdatabase.* TO 'username'@'localhost' IDENTIFIED BY 'password';