Connection to MySql database from command prompt

[pawanez4u]

Hi All,

I am a PHP programmer, i am using XAMPP software for programming and Mysal as a Database. I want to use my MySql database from command prompt. Help me how to connect,create databases in MySql from Command prompt.

Thank you

Pavankumar P

[r035198x]

Hi All,

I am a PHP programmer, i am using XAMPP software for programming and Mysal as a Database. I want to use my MySql database from command prompt. Help me how to connect,create databases in MySql from Command prompt.

Thank you

Pavankumar P

What happens when you type

mysql

on the command prompt?

[ronverdonk]

From the command line you go to the MySQL library, e.g.:

cd c:\"Program Files"\MySQL\"MySQL Server 5.0"\bin
 

Then you connect to the MySQL server:

mysql -u userId -h Hostname -p
 

MySQL can request a password:

Enter password: ********
 

When successfuly, youll see the following messages (or alike):

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 166 to server version: 5.0.24a-com
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql>
 

now you can issue the SQL statements to handle your databases, tables, etc. from here on.

To exit the MySQL simply type:

exit
 

Good luck.

Ronald

[lanlife]

If you are using Xampp you can have access to mysql from console by pointing to mysql executable directly such as

On linux
try /opt/lampp/bin/mysql
if you install xampp to /opt/
if it works then try to link by

ln /opt/lampp/bin/mysql /usr/bin

then after that you can now use
"mysql" to the command to access it.

For windows

C:\xampp\mysql\bin\mysql -h localhost -u root -p
when it ask for password press enter if you don't use password for mysql

Then add mysql path C:\xampp\mysql\bin\mysql to system variable
to access mysql directly by typing mysql.

Hope this help.