Page 1 of 1

MySQL problem

Posted: Sat Dec 06, 2003 12:14 pm
by Dingbats
I've created a database, with one table in, but I don't remember what it's called! Is there any way do view this? Like an interface or so? :?

Posted: Sat Dec 06, 2003 12:42 pm
by Weirdan
use mysql command line tool:

Code: Select all

weirdan@home:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.14

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+-----------+
| Database  |
+-----------+
| books     |
| mysql     |
| profiling |
| test      |
+-----------+
4 rows in set (0.06 sec)

mysql> use test
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| ltest          |
| newuser        |
| tram           |
+----------------+
3 rows in set (0.01 sec)

Posted: Sat Dec 06, 2003 7:01 pm
by DuFF
or install phpMyAdmin which is a GUI for MySQL databases :D

Posted: Sat Dec 06, 2003 8:35 pm
by infolock
just adding to wierdan :

the instructions on how to use the command line tool and all of the options for displaying table or database information is located in your MANUAL that's included in teh directory you installed mysql.

if you are on windows, and installed mysql to c:\mysql
then your manual will be in c:\mysql\docs\manual.html

scroll down to about section 3.1 and it will show you all the things you need to know, including the beginning syntaxes you should become familiar with.

also good to know if the manual localed on http://www.mysql.com

Posted: Sun Dec 07, 2003 12:38 pm
by Dingbats
And how do you use phpMyAdmin? And yes, I've read the manual, but I didn't understand.

Posted: Sun Dec 07, 2003 2:33 pm
by JAM
Change the config.inc.php file, to fit your needs. Likely $cfg['PmaAbsoluteUri'] and the first couple of $cfg['Servers']* ones, to start with.

More info is available in the Documentation.txt file, under the Configuration section.