MySQL

[PrNcSsChRmNg91]

Hello. I'm currently hosted and my hostess does have mySQL. I need to access the mySQL to create a username. My hostess gave me my db name and password already. How do I access the mySQL?

Thanks!

 

[pgp_protector]

You would connect to the MySQL Database by the command in a PHP file (Running on the webserver)

<? 		
@ $db=mysql_connect('localhost','username','password');
  if(!$db) 
	{ 
	exit; 
	}			//Unable to connect to database  Quit with a smile :)
  mysql_select_db('databasename',$db);
?>

A really good book to get is Visual Read Less-Learn More MySQL

now if you want to connect from your computer, I would suguest finding a program called MySQL-Front

 

[trunks2k]

Hello. I'm currently hosted and my hostess does have mySQL. I need to access the mySQL to create a username. My hostess gave me my db name and password already. How do I access the mySQL?

Thanks!

Well there are numerous ways to access MySql. And I'm not entirely sure what you mean by creating a username. Do you mean creating a username for your website or for the MySql database itself?

The documentation for mysql can be found at: http://dev.mysql.com/doc/

If you have shell access to the server, you can shell into the server and alter the database directly. By following the directions in the documentation.

You can also access MySql via a PHP with the directions given above. to perform a query, you need to have the script connect to the database as given above. Then any query can be run with the line:

mysql_query("THE QUERY YOU WANT TO RUN", $db);

A query is any alteration or innspection of the mysql database. See the MySql documentation on what types of queries you can run (including adding users to the database itself).

Alternately, you can use a front end to the database. I personally use PHPmyAdmin found at: http://marketplace.viaverio.com/modules.php?name=News&file=article&sid=36

PHPmyAdmin doesn't allow you to add or remove users for the databse itself (at least not by default, there may be an option to set).

There's a really nice, simple tutorial on how to use PHP and MySql at:
http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html

 

[QuePasa]

type
man mysqladmin
to get to some documentation regarding using mysql from the command line. You'll probably need to load some .sql database files to get phpmyadmin (awesome tool) running.