 Mysql, administration |
|
|
|
|
  |
  Jun 27 2007, 03:23 PM
Post
#1
|
|
|
Newbie [Level 3]  Group: Members Posts: 48 Joined: 21-June 07 From: lebanon Member No.: 45,185  |
QUOTE Using your MySQL administration tool that your web host has, check to see if the table was created correctly. Afterwards, try creating a few of your own tables to be sure that you have gotten the hang of it. Where is the MySQL administration tool on trap17 O_o, i can't find it. |
 |
 
|
|
Jun 27 2007, 03:45 PM
Post
#2
|
|
|
Administrator  Group: Admin Posts: 1,459 Joined: 11-June 04 From: Somewhere in Time & Space. Member No.: 1 |
CPANEL -> MYSQL.
For administration, use PHPmyAdmin @ CPANEL -> MySQL Databases -> PHPmyADMIN |
|
|
|
|
Jun 27 2007, 04:31 PM
Post
#3
|
|
|
A clever man learns from his own mistakes, a WISE man learns from those of OTHERS Group: [HOSTED] Posts: 976 Joined: 12-April 06 From: Essex, UK Member No.: 21,719 |
One thing i had an issue with is understanding how to create users and databases, to do this use the tool "Mysql Databases" in cpanel. For any table/data entry/deleting etcetera use the phpmyadmin tool in cpanel. Note that from phpmyadmin you cant create new databases or users, only new tables and edit the data in the table.
|
|
|
|
|
Jun 27 2007, 07:39 PM
Post
#4
|
|
|
Member [Level 1] Group: Members Posts: 60 Joined: 25-February 07 From: Somewhere Your Not! Well... Maybe your here. Who Knows? Member No.: 39,197 |
Well you would just click on databases are if you want you can click on your phpMyAdmin and type in
CREATE DATABASE 'dbname'; Just replace dbname with the database you desire and it should work depending on how trap 17 has installed there mysql and phpmyadmin |
|
|
|
|
Jun 28 2007, 07:35 AM
Post
#5
|
|
|
Newbie [Level 3] Group: Members Posts: 48 Joined: 21-June 07 From: lebanon Member No.: 45,185 |
CODE <?php mysql_connect("localhost", "admin", "1admin") or die(mysql_error()); mysql_select_db("test") or die(mysql_error()); mysql_query("CREATE TABLE users( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(30), age INT)") or die(mysql_error()); echo "Table Created!"; ?> Where do i put this in mysql administration? and is there anything wrong with it? P.S.: I got it from a friend so i doubt he'd sue me for copy rights 
|
|
|
|
|
Jul 13 2007, 07:09 AM
Post
#6
|
|
|
Super Member Group: [HOSTED] Posts: 209 Joined: 12-July 07 From: Canada Member No.: 46,349 |
dont sweat it I couldnt find it either. Im used to creating and managing the database in phpAdmin and i didnt want to ask where to set up a database because I felt like a noob. Luckily i realized after i read this post, that beside phpAdmin is a MYSQL Database link... hehe so I'm all good now.
|
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 6th September 2008 - 02:29 AM |