mysql: how do i get a list of databases available?

Posted by every_answer_gets_a_point on Stack Overflow See other posts from Stack Overflow or by every_answer_gets_a_point
Published on 2010-04-26T23:47:38Z Indexed on 2010/04/26 23:53 UTC
Read the original article Hit count: 145

Filed under:

mysql

|

wampserver

|

sql

i am using wampserver

i opened the mysql prompt

i would like to know which databases i am able to connect to/view. how do i do this?

© Stack Overflow or respective owner

Related posts about mysql

How to remove MySQL completely with config and library files on ubuntu 12.04 gnome 3.0

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I tried everything till now: sudo apt-get remove mysql-server mysql-client mysql-common sudo apt-get purge mysql-server mysql-client mysql-common sudo apt-get autoremove and even more commands... But whenever I am trying to locate mysql. I get a no. of files related to mysql command: shell>>… >>> More
mysql: Cannot load from mysql.proc. The table is probably corrupted

as seen on Server Fault - Search for 'Server Fault'
Mysql was started: /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 but when I'm trying to do something: ERROR 1548 (HY000) at line 1: Cannot… >>> More
Why is there a /etc/init.d/mysql file on this Slackware machine? How could it have gotten there?

as seen on Server Fault - Search for 'Server Fault'
A client of my IT-consulting service owns a web-development shop. He's been having problems with a Slackware 12.0 server running MySQL 5.0.67. The machine was set up by the client's sysadmin, who left on bad terms. My client no longer employs a sysadmin. As far as I can tell, the only copy of MySQL… >>> More
mysql: Bind on unix socket: Permission denied

as seen on Server Fault - Search for 'Server Fault'
Can't start mysql with: sudo /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 120222 13:40:48 mysqld_safe Starting mysqld daemon with databases… >>> More
MySQL – Learning MySQL Online in 6 Hours – MySQL Fundamentals in 320 Minutes

as seen on SQL Authority - Search for 'SQL Authority'
MySQL is one of the most popular database language and I have been recently working with it a lot. Data have no barrier and every database have their own place. I have been working with MySQL for quite a while and just like SQL Server, I often find lots of people asking me if I have a tutorial which… >>> More

Related posts about wampserver

How to install Ruby on Rails alongside WampServer ?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is is possible to install Ruby on Rails alongside WampServer (and keep WampServer's Apache/MySQL installs)? >>> More
configure firewall not to block wampserver from being access on lan

as seen on Server Fault - Search for 'Server Fault'
how do I do I configure the firewall so that it wont block wamp server from being access from other computers on my home network? >>> More
how to connect to wampserver from the other computer

as seen on Server Fault - Search for 'Server Fault'
I have two computers. with both windows 7 as os. One pc has wampserver installed how do I connect them so that the other one can access the database that is in the other pc. I have a hub that connects both physically but how do I set it up in the os? >>> More
How to install FFMpeg in WampServer 2.0 (Windows XP)

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to install the ffmpeg PHP extension on my localhost so I can test few of my scripts but I am having troubles figuring out how to do that. I have WampServer 2.0 with PHP 5.2.9-2, my OS is Windows XP. Please somebody give me step by step instructions. I have found some Windows builds here:… >>> More
Need Help Accessing the Vista Wampserver localhost from Virtual PC 2007 running an XP VM.

as seen on Server Fault - Search for 'Server Fault'
(I had posted this on stack overflow but it was suggested there that I post it here instead). I have a Vista laptop on which I'm running wampserver. I have Virtual PC 2007 setup with Windows XP running on the VM. My goal is to be able to use the XP VM to run IE6 to view the localhost in the Vista… >>> More