How to get the MySQL module to start in the XAMPP control panel
- A2A.
A) Windows : Is the panel as shown below ?
Check the my.ini. Is it similar to:
- # Here follows entries for some specific programs
- # The MySQL server
- [mysqld]
- port= 3306
- socket = "C:/xampp/mysql/mysql.sock"
- basedir = "C:/xampp/mysql"
- tmpdir = "C:/xampp/tmp"
- datadir = "C:/xampp/mysql/data"
- pid_file = "mysql.pid"
- # enable-named-pipe
- key_buffer = 16M
- max_allowed_packet = 1M
- table_cache = 64
- sort_buffer_size = 512K
- net_buffer_length = 8K
- read_buffer_size = 256K
- read_rnd_buffer_size = 512K
- myisam_sort_buffer_size = 8M
- log_error = "mysql_error.log"
- # Change here for bind listening
- # bind-address="127.0.0.1"
- # bind-address = :: # for ipv6
Check if xampp/mysql is properly installed. Try “cd xampp/mysql/bin” followed by mysql -u root -p. If it responds with a
mysql>
then MySql is running.
Otherwise uninstall/reinstall xampp.
B) Ubuntu Linux:
xampp is normally installed under /opt/lampp.
/opt/lampp/manager-linux-x64.run starts the control panel.
Go to Manage Servers tab.
Start the MySql Database
Open a new terminal and type:
mysqladmin -u root -p status
You should see a result similar to:
Mysql is running. You can use the command mode interface with
mysql -u root -p