How do I start the MySQL console in XAMPP?

The XAMPP installation is done. XAMPP is up and running.

What about the MySQL console? How is possible to start the MySQL console to run some special SQL statements?

Solution 1:

just start mysql using the command

example: sudo /opt/lampp/lampp startmysql

and find path of mysql , it will be placed in bin directory of lampp, then login

example: /opt/lampp/bin/mysql -u root

Solution 2:

From the terminal type mysql -uUSER -pPASSWORD DATABASE which is:

mysql The actual command to use mysql

-uUSER is what user will connect. The -u is the parameter for the user and the USER part is the actual name of the user.

-pPASSWORD is the password for that user. the -p is the parameter for the password and the PASSWORD is the actual password.

the DATABASE part is optional. Is just if you want to connect directly to a particular database. For example, let us say the user cyrex with password ubuntu wants to connect to the database linux, you would type this:

mysql -ucyrex -pubuntu linux (User is cyrex, password is ubuntu and the database is linux)

if you do not add the database you can eventually go to it by using the use statement of mysql or searching for the database with show databases;

Solution 3:

Maybe you're wondering about the package Apache Friends Xampp. The only way init is MySql

~$ sudo /opt/lampp/lampp startmysql

If it's something

Solution 4:

The latest version of Xampp's Control Panel has a shell button, click that and it may show a dialog box saying that the #bat file needs to be created, and if it should create it now.. You should say Yes.

After that, it will open a console window. From that console window you can easily access mysql by typing the following.

mysql -u mysqluser --p mysqlpass

in my own personal installation i use the below (because i don't have a pass set for user @root).

mysql -u root

Btw, if it isn't obvious already I am using windows, so there could be some differences in the ubuntu version.

Hope this helps someone..

Solution 5:

First use this command in shell (Ubuntu):

ubuntu@ubuntu-PowerEdge-2850:~$ sudo /opt/lampp/lampp startmysql 

Second use this command in shell (Ubuntu):

ubuntu@ubuntu-PowerEdge-2850:~$ /opt/lampp/bin/mysql -u root -p database < "/opt/lampp/htdocs/database.sql" 

Enter password: (Press Enter)