PDA

View Full Version : MySql?



308holes
November 6th, 2005, 22:59
Ok i have been out of the game a while and starting to get back into things i signed up with a Windows host and am trying to make a MySql DB i have made the data base. but have no clue on how to creat the contect because last host had phpMyAdmin and some other tools that made it easy to creat it.and im Lost i dont know how to connect to the database to add the tables any one help me out !! i am using a winXP
this is the info that was given to me fron the server


You have access to one mySQL database that you can use.

Database Name: dscwolonline
Username: dscwolonline

Please note that when connecting to the database from a script on your website you must use the internal server IP on our network which is 192.168.16.152
If you are connecting externally using MySQL connection software the IP is 208.172.157.114

bloodyveins
November 7th, 2005, 01:37
some cases:
- you create a php script to be uploaded to your host


$dbhost = '192.168.16.152'; //private ip for the db host
$dbuser = 'dscwolonline';
$dbpass = ''; //contact your host
$dbname = 'dscwolonline';

mysql_connect($dbhost,$dbuser,$dbpass) or die(_put_your_error_handler_here_);
mysql_select_db($dbname) or die(_put_your_error_handler_here_);

if you're accessing it from console (windows/*nix)
windows:


c:\>mysql -h 208.172.157.114 -u dscwolonline -p

*nix


shell>>mysql -h 208.172.157.114 -u dscwolonline -p

check php manual and mysql manual for more info.

regards,

308holes
November 8th, 2005, 01:35
i dont have mysql installed on my pc?

Tree
November 8th, 2005, 09:43
You should be able to connect to the command prompt remotly through your host. If you can't you're with the wrong host.