MySQL problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Dingbats
Forum Commoner
Posts: 25
Joined: Fri Dec 05, 2003 10:53 am

MySQL problem

Post 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? :?
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post 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)
User avatar
DuFF
Forum Contributor
Posts: 495
Joined: Tue Jun 24, 2003 7:49 pm
Location: USA

Post by DuFF »

or install phpMyAdmin which is a GUI for MySQL databases :D
User avatar
infolock
DevNet Resident
Posts: 1708
Joined: Wed Sep 25, 2002 7:47 pm

Post 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
Dingbats
Forum Commoner
Posts: 25
Joined: Fri Dec 05, 2003 10:53 am

Post by Dingbats »

And how do you use phpMyAdmin? And yes, I've read the manual, but I didn't understand.
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post 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.
Post Reply