Xampp mysql not starting. November 09, 2020 11:58AM Jan 23, 2013 · 1.

Mar 9, 2019 · Go to "services" listed on the right side. And last restart your xampp control panel and start the apache and mysql server. Find again and change line ServerName localhost:80 to ServerName localhost:7777. If I go to XAMPP this is what is printed: Dec 26, 2017 · Thanks for the answers. In the XAMPP Control Panel, click on the Apache – Config button which is located next to the ‘Logs’ button. sudo apt-get autoremove. In the left pane, click on “New rule”. Provide details and share your research! But avoid …. download xampp from the site. The Control Panel is now visible, and you may use it to start or stop any module. EDIT: See full list on kinsta. In my case It fixed by: Starting xampp-control. So I set appropriate folder permissions on c:\xampp helped to run the services normally. InnoDB: 2) If the table is not needed, or you can restore it from a backup, InnoDB: then you can remove the . I changed session storage and get next level of headache: #2002 - No such file or directory — Server isn't responding (or local socket of Mysql incorrectly configured ). Create a new file with. Dec 7, 2023 · Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Oct 28, 2020 · To start a MySQL (technically mariadb) module from the XAMPP control panel, you just click the "Start" action button. 62. Open xampp. 16:27:46 [main] Control Panel Ready. (2) unistall service module and then install service module. In there theres a CONF file/configuration file named httpd. type: in mysql -u root -p then press enter. Find out how to check your error logs and access your PHP log for more details. Beneath from the 'With selected' dropdown, run 'analyze' (it should say that it is corrupted). In this section, we will show you how to open MySQL in XAMPP. I tried changing the port . Feb 23, 2018 · 16:27:46 [mysql] Expected Path: c:\programmieren\datenbanken\xampp\mysql\bin\mysqld. 2. ini mysql. Oct 30, 2016 · MySql does not start in XAMPP v3. To Resolve MySQL Port and Service conflict when already another MySQL Server is running, you need to follow following steps:-. bat. Try this Stop MySQL Services. Scroll down & right click on "mysql" and go to "properties". Locate "World Wide Web Publishing Service". Xampp and MySQL not started. Open data_old folder, copy all folders except mysql folder, performance_schema folder and phpmyadmin Nov 22, 2017 · Tech WinLin,This Video tutorial has describes about how to solve mysql error in xampp server?Youtube Link : https://youtu. Step 3. To edit the configuration file, open my. It will start it automatically. root folder. 3\. If you have issue stopping then do following. Look for the line that says " Default options are read from the following files in the given order: " and note the location of the MySQL configuration file. So in this video we have fully solved the error of " MySQL crashed in XAMPP Hi Friends! In this video, We're going to see How to solve MySQL not Starting in the XAMPP Server. I was tryin to start the mysql service when already one is already running. It will open XAMPP automatically. Then for not starting this "3306 port" program, launch services. Kill (close) that application and try starting MySql now it should now work fine. To access SQL via the command line we simply navigate to the xampp folder. (for example: C:\Program Files\MySQL\MySQL Server 8. run security program in terminal. Dec 10, 2015 · For the xampp users, you just need to replace following files from Xampp/mysql/backup folder to Xampp/mysql/data folder (FYI: Keep a backup copy of data folder before actioning just to be on a safer side. Select the View tab and select Show hidden files and folders. open xampp control panel, you should see mysql is running. sudo mysqld_safe --skip-grant-tables &. @WilsonHauck I checked services and nothing coming up with search keyword mysql prnt. conf)“. If that did not work and "World Wide Web Publishing Service" was not available, Go to the Control Panel, navigate to "Uninstall Programs", then "Turn on/off Windows features". Start Apache Services& MySQL Service. So do next steps: Rename folder mysql/data to mysql/data_old. xampp MySQL does not start. I have problems with MySQL server that is not running: Nov 29, 2020 · xampp MySQL does not start. Its also disable all db using innodb engine. Its not working . Close XAMPP Server. Create a new folder called FIX Start phpMyAdmin from your browser and select the table 'db' from the database 'mysql' (Select 'mysql' from left panel then check 'db' in right hand panel). If you are unable to start MySQL, it is likely that the port 3306 is already in use. Open the MySQL configuration file and look Find possible solutions for the common problem of Xampp MySQL not starting on Windows. What command is being run behind the scenes for "Start"? I've tried to replicate it from the command line with a variety of commands, but I've found that the "Start" button will succeed where my command-line commands fail. service nothing showed up 4. Jun 2, 2015 · I imported another database and working on this new database was fine. ini --standalone --console. Step 7 is to Find “Listen 443” and change it to Apr 26, 2017 · Install new xampp. (Notepad should open) Do Ctrl+F to find ’80’ and change line Listen 80 to Listen 7777. Jan 15, 2015 · Not start mysql in xampp 7. Feb 3, 2023 at 9:23. (3) now try start the apache and mysql. May 31, 2019 · Go to Start -> Control Panel -> Windows Defender Firewall. ~$ sudo /opt/lampp/lampp start. command for password reset (if required) Make sure that your file is in C: drive. 47. the folder is usually on the c:\ drive. mysqld --defaults-file=mysql\bin\my. try removing mysql completely from ubuntu and try again. Create a data folder in C:\Program Files\MySQL\MySQL Server 8. ini looks as if you already have two services running: one from C:\Program Files\MariaDB 10. sc/E13s67fPuPEc. Apr 15, 2015 · There should be number near the top, something like 739 or 8827. Peter Brawley. Step 2. Go to Start and type "services. exe, and run as administrator. I thought that the 3306 port was blocked but I checked and nothing is running on that port. To do this, follow the steps below: Open the XAMPP Control Panel. Mysql run by default on port 3306. mysqli_real_connect(): (HY000/2002): No such file or directory. Copy all your database folders from mysql/data_old into mysql/data (except mysql, performance_schema, and phpmyadmin folders) Jun 21, 2021 · Next you can delete the data directory. Hot Network Questions Cleaning chain a few links at a time Folk stories and notions in mathematics that are likely false, inaccurate Mar 24, 2022 · 5. 20 hours ago · Whenever i try to start MySql service in xamp, it starts for about a second, and then stops. Apache port changed: 80 -->81 Mysql port changed: 3306-->3307 Earlier i had mysql already, but i uninstalled it. Go to " config " at top-right corner of the Xampp window, click on " service and port settings ", go to " mysql " tab and change the " main port " to 3308 or something else. pankti shah. InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB Apr 17, 2014 · mysql is not starting in XAMPP UBUNTU. 00000001 with the following command : sudo nano [filename]. Start -> Run, type in services. run this query in mysql. answered Jul 21, 2022 at 12:46. Click on the “Inbound Rules” option. if it is not available then search it into your drive and put the xampp folder as it is. Search for process: ps aux | grep mysqldKill the process: kill -9 process_id. In the command line, type myisamchk -r /path/to/your/table. . user. Kill it. Mar 30, 2009 · 2. . 127. I also see your innodb_buffer_pool_size is very low. ibd file, and InnoDB will do a normal InnoDB: crash recovery Nov 8, 2020 · XAMPP MySQL not starting. kill -9 {process id} this should look something like this: kill -9 739. Sep 15, 2023 · Check out this article if the video doesn't have a solution you need:https://blog. execute the following command. XAMPP MySQL Database Jul 3, 2024 · So, follow these suggestions: Open the XAMPP Control Panel on your Windows device. You can do this by opening your XAMPP control panel and clicking on "Config" next to the mysql button. Click on Start, type in Show hidden files and folders. Mind you, I had set the firewall to be disabled at start up (clean start-up - all startup programs disabled through MSConfig). Mysql shutdown unexpected 2. Aug 23, 2019 · This Tutorial helps to [Solved] XAMPP : MySQL and phpMyAdmin don't workDear Friends, Backup Database Before doing this TutorialThanks friends for watching th Hello Everyone! Today in this video I am going to step by step guide you How to install solve MySQL not Starting in the Xampp Server problem. (Ur installation directory may as well be different). I've already tried to fix it, but I couldn't find any actual solution, I hope you can find what's wrong with it. Dec 9, 2018 · The easiest way to fix this will be by switching it to a different port. 5 Xampp Mysql wont start. Sep 22, 2020 · 7. in the new line enter the password of the database. com/2022/08/xampp-mysql-not-starting-on-windows/XAMPP is a grea Jun 18, 2022 · Choose MySQL Database in manager-osx and click Configure. Mar 21, 2024 · Go to the bin folder inside your XAMPP’s MySQL directory by typing cd followed by the path, like C:\xampp\mysql\bin for Windows users. conf. In my case I gave full control to current windows user to the xampp folder. So your problem is the non-starting MySQL service. Failing that, a fresh install of xampp to restore defaults should do the trick. edited Nov 12, 2022 at 6:03. Select ‘Apache (httpd. I have updated my XAMPP version to 1. Aug 6, 2020 · I'm using XAMPP for Windows and MySql was working fine for the longest time, but now (after a Windows update I think) it crashes on start-up. Then Copy same file (ib_logfile0,ib_logfile1 and ibdata1) from Nov 13, 2018 · MySQL uses 3306 as it’s default port. then . You can find the service panel by. 15. REPAIR TABLE mysql. Tried to access log files in /opt/lampp/var/mysql, tried to access the following files: ib_logfile0, ib_logfile1, aria_log. conf files. Check by starting apache and mysql again with Nov 2, 2022 · xampp MySQL does not start. ini. Once you find it, shut it down and try starting xampp's mysql service. November 09, 2020 11:58AM Jan 23, 2013 · 1. “We are almost done to fix localhost/phpmyadmin” Step 6: Again go to config and select “Apache (httpd-sss. use following command to check app occupying a port Apr 1, 2022 · I'm using Ubuntu 21. 0\data folder. There's the log: 2019-06-26 9 Mar 1, 2018 · 0. I made sure that the firewall program was not running at all in my services. It just says "attempting to start Tomcat service". sudo service apache2 stop. Make a copy of mysql/backup folder and name it as mysql/data. XAMPP MySQL Step 2: Starting XAMPP Oct 13, 2021 · If your MySql is new without important databases, you can try these steps: Shut down your Xampp server. use following commands to uninstall mysql. The Windows Defender Firewall window opens. Go to C:\xampp\mysql\data directory. 19 2. I can access a php file in htdocs in my browser. 8. PM 03:06:44 [mysql] Change XAMPP MySQL and Control Panel settings or. Find the 'my. 16 1 3. ) Jan 19, 2024 · To check, Ctrl,ALT,DEL for Task Manager and look under Services for MySQL and if running, STOP it. msc". Just started up Xampp today and when I turn on my SQL, it simply turns off again and tells me that MySQL shutdown unexpectedly. I seem to have a problem now with Tomcat. If I try to start the Apache Web Server (in 'Application manager'), it says "starting. 1. However, for some reason I cannot start the MySQL server in the F:/xampp any more. 3 MySQL not launching on XAMPP. 3. Nov 27, 2019 · Mysql is not starting in xampp. https://www. $> mysqladmin -h host_name variables. Jun 21, 2016 · How to import an SQL file using the command line in MySQL? 15 XAMPP/MySQL: could not open single-table tablespace file . save_path is correct (/tmp) in Unknown on line 0. I am getting 1. Fixing the MySQL server not starting in XAMPP is done by reverting back the data files pre-issue. Mysql on XAMPP server wont start. sudo apt-get purge mysql*. Checked the service list for mysql. November 08, 2020 09:39PM Re: XAMPP MySQL not starting. Dec 4, 2023 · The MySQL server in XAMPP does not start well anymore. Open another shell from control panel and repair database with this command: mysqlcheck -r --databases mysql --use-frm. For example, If you have 2GB ram, then set buffer_pool_size= 1GB. ini (C: is the default XAMPP Installation) Replace the port number 3306 with 3307. The logs will most likely say unexpected shutdown or “Index for table ‘. MySQL Database won't start in XAMPP Manager-osx. Daniyal. Step:2 follow image below: Check the corrupt tables and then click on the dropdown beside Check all and from the dropdown list select Repair table from the Table Maintenance group. run the uninstaller. 0. Run Command Prompt as Administrator and execute the following command to stop and remove MySQL service. 10 & Xammp 8. Aug 20, 2023 · Please try to start MariaDB as console application and tell us what log messages you get there: start the XAMPP shell by clicking the [Shell] button in your XAMPP control panel. edited Aug 23, 2020 at 22:58. exe --defaults-file=c:\programmieren\datenbanken\xampp\mysql\bin\my. youtube. If you need the other application (who was using port 3306) make sure Mysql start first so the other application find some InnoDB: To fix the problem and start mysqld: InnoDB: 1) If there is a permission problem in the file and mysqld cannot InnoDB: open the file, you should modify the permissions. Dec 21, 2023 · MySQL not starting in XAMPP can be a frustrating problem, but fortunately, it can be fixed by following the steps above. Dec 7, 2017 · It looks like MySQL isn't binding to your localhost, and therefore can't bind to a port on said host, and won't start because of that. type: cd c:\xampp\mysql\bin then press enter. ini MySQL. 2. I think the actual MySql and Apache we installed on our system were having some conflict with the XAmpp's apache and mysql. Once you determine the path settings you want, start the server without --verbose and --help . Now I have the problem that the MySQL Database-server won't start. exe as administrator. I tried changing the port as recommended here, and the server still does not start, although it attempts to do this: a new PID is shown for a fraction of second next to MySQL in the context of the screenshot below when clicking on Start. Change the port number to a new one, for example: 3307. Xampp Mysql wont Apr 3, 2020 · Drag and drop the XAMPP control panel to the above directory. Hot Network Questions Jul 24, 2019 · HeidiSQL would just connect over port 3306 to your MySQL instance, but it does not listen to any port, so it does not use any port as you say. All in all I found that xampp (1. Open the file using any text editor and then try finding the number 80 manually or usiong a finder ( Ctrl + F in notepad++ for ex. Copy and paste the backup folder named backup_copy. Jan 23, 2024 · Here's how: Open the XAMPP control panel. The first step in troubleshooting the issue is to check if MySQL is running. # password = your_password. answered Feb 24, 2018 at 8:40. Under “Rule Type” select the Jan 23, 2017 · In Xampp > Click NetStat it will show you all application with there running ports. Run the installer for xampp. Increase the buffer_pool_size to about 50-60% of your RAM. Dec 16, 2020 · I am new to MySQL and I don't know why but MySQL does not start with XAMPP. move your stuff back to the xampp folder. you need to check if another application is occupying that port. Deleting ibdata1 file may destroy your tables, backup everything. Nov 25, 2013 · Check whether you have a another mysql service running on same port 3306. Stop you apache Services. Jan 23, 2019 · 10. answered Oct 13, 2021 at 20:56. See how to check error logs, change ports, stop services, reinstall MySQL, and more. Copy your old database folder from xampp\mysql\data\databasefolder to Paste in your running xampp folder C:\xampp\mysql\data. Jul 21, 2020 · Hello friends, Thanks for watching the video "MySQL not starting in XAMPP server". XAMPP is a free and ope Feb 27, 2012 · Replace “Listen 80” to “Listen 8080“. MySQL not launching on XAMPP. 0\bin) mysqladmin -u root -p shutdown. – Wilson Hauck. Again find another “Listen” now change “ServerName localhost:80” to “ServerName localhost:8080” and then save it. If runnning then stop the process:(Make sure you close all mysql tool) sudo service mysql stop. Net stop MySQL. 1. The Windows Firewall with Advanced Security Window opens. Sc delete MySQL. The following commands : 3. The Apache server does start. This command will safely shut down your existing MySQL running on port 3306 so that you can access the same port Oct 29, 2016 · start xampp (as administrator), (1) right click C:\xampp\xampp-control. Select Apache (httpd. Show column pid (Menu > Select > Column selection > check PID) You know the program which uses this 3306 port. msc, click OK. 0. $> mysqladmin variables. Then also same message is popped up. edited Dec 9, 2018 at 20:14. To start the Apache, MySQL and ProFTPD server you have to just type the following command. Type " mysqld --verbose --help " and press enter. If it is not running, try to start it. Then execute the below command: All I needed to do was create the C:\Program Files\MySQL\MySQL Server 8. PM 03:06:44 [mysql] Found Path: c:\xampp\mysql\bin\mysqld-nt. xampp doesn't start mysql. This one helped for me: Open shell from from control panel and start mysql with this command: mysqld –-console –-skip-grant-tables –-skip-external-locking. Dec 25, 2021 · Try deleting the file at path 'C:\xampp\mysql\data\ibdata1' and restart xamp. first check your xampp folder where apche/bin and mysql/bin is available or not. Cant start MySQL Server from XAMPP. Your my. and one from C:\xampp\mysql\. As Apache port, we also can NOT change the MySQL port through the XAMPP Control Panel, to change it we have to edit MySQL configuration file. Restart your XAMP. Stop mysql, close shells and restart mysql normally. Asking for help, clarification, or responding to other answers. Jan 20 at 1:22. conf)’ from the drop down. But when I click on the "Start" button in the XAMPP Control Center the text "Running" flashes up in green for a second (see linked picture above) and vanishes again. In the left-hand list, Click on the “Advanced Settings” link. 2020-09-22 9:28:33 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. 5. Xampp Mysql wont start. "Attempting to start mysql" and a pop up windows is coming regarding net solution to start. Oct 28, 2014 · backup files and database (if possible) quit 'manager os x'. I also have the following odd symptoms. Check the 'MySQL' module to see if it is running. db. Open file C:\xampp\mysql\bin\my. cnf mysql. 5) Restart MySQL in manager-osx If I type in terminal sudo . PM 03:06:44 [mysql] Expected Path: c:\xampp\mysql Jul 7, 2023 · The fix. This may be due to a blocked port, missing dependencies, 3. I am getting below errors . Apache web server & ProFTPD servers are running well. Sep 25, 2015 · 1. 1 Sep 10, 2017 · Please verify that the current setting of session. sudo service mysql stop. Rename the backup_copy folder to data. Nov 24, 2017 · 2. Feb 10, 2024 · Checking if MySQL is Running. Close the config file and click OK. improper privileges, a crash, or a shutdown by another method. Jul 30, 2013 · First, navigate to xampp's directory (default is c:\xampp) and double click apache_start. Mar 3, 2023 · Please try to start MariaDB as console application and tell us what log messages you get there: start the XAMPP shell by clicking the [Shell] button in your XAMPP control panel; execute the following command Code: Select all mysqld --defaults-file=mysql\bin\my. Click Open Conf File and change the port number in the file. Instead, first try using the MySQL backup folder which is included with XAMPP. Once you find which application is running on port 3306. Aug 24, 2015 · 75. Then select again and run 'repair table'. 5 Mysql on XAMPP server wont start. [2024 U Feb 2, 2024 · XAMPP MySQL Step 1: Opening XAMPP. Jul 28, 2014 · MySQL Service detected with wrong path. It is certainly a MySQL, search for it and desactivate it at startup. Oct 15, 2019 · 38. delete the xampp folder. 11. To open the MySQL or MariaDB console (Terminal) you have to just type the following command. I fixed it, here is how: Close the Xampp application ( preferably using task Manager) Open C:\xampp\mysql folder. Share. Right-click on that entry, select "Stop", then restart XAMPP. com May 1, 2022 · 1. It's because the mysql installed in ubuntu takes over the port which will inturn block the mysql of xampp. In there the file location would be : C:\xampp\apache\conf. If you want to auto start Apache and MySQL, click on config in XAMPP and check the Apache and XAMPP items (if unchecked) and save it. 4. delete the ibdata1 file. sudo apt-get autoclean. After that stop mysql and apache service then backup your running xampp files ib_logfile0,ib_logfile1 and ibdata1 and store in safe place. Delete aria_log_control ( Check this location -> pc/c drive / xampp folder / MySQL folder / data folder / aria_log_control ) Exit from the all folders. 16:27:49 [Apache] Attempting to start Apache service 16:27:50 [mysql] Attempting to start MySQL service solve Xampp apache not satrting because of port problem in 2 easy steps with Idiot Logics. ;) – Open Xampp. Code: Select all. MYI with the real path to the MyISAM table you need to fix. Oct 29, 2010 · Finally, I decided to uninstall the Windows 7 Firewall Control program made by Sphinx Software. Click on the Config button of the Apache module. i. be/GT0inFBSgpYgoogle Plus :https Jan 8, 2015 · If mysql is not starting in xampp, it might be a port conflict issue. \mysql\innodb_index_stats. It is ticked green in the module services column of the control panel however i cannot start it. ini file located in the XAMPP/mysql/bin/ directory, find words that contain number 3306, eq: port = 3306, then replace it May 7, 2013 · 10:09:36 AM [mysql] Expected Path: c:\xampp\mysql\bin\mysqld. ~$ sudo /opt/lampp/bin/mysql. After that, click my. Now, in Xampp, click on " config " in the Mysql row (click on Mysql's "config"), and open " my. terresquall. Now start mysql in safe mode with skip grant. Here is the log: 2020-09-22 9:28:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Nov 12, 2016 · I tried to change the port also and I did it but it is showing me the same message. After that, in the text file, edit the port to whatever you wanna use. Rename the data folder to data_old. Everything worked fine. The Configure window for XAMPP’s MySQL service. Navigate to your XAMPP MySQL directory ( C:\xampp\mysql ). MySQL won't start on XAMPP server. ibd after restart of MySQL Apr 27, 2021 · Learn how to troubleshoot common issues that prevent XAMPP from starting, such as Apache port conflicts, PHP errors, and MySQL problems. ini --standalone --console Jul 13, 2018 · xampp MySQL does not start. conf) option from the list of the pop-up My solution: Just head to the folder of bin in MySQL server on your machine and run this command from that directory in your command prompt. Check your config file in MySQL to make sure it's set up correctly. PM 03:06:44 [mysql] Uninstall/disable the other service manually first. Reinstalling Xampp completely. Error: MySQL Shutdown Unexpectedly. Go to your system’s XAMPP folder or simply click the XAMPP Icon to open it. com/channel/UCz0KhXnBikEvp5lD0XI2btQhow to sol Oct 27, 2013 · Get the pid for 3306. By checking the XAMPP control panel, looking for conflicting ports, checking the MySQL error log, and reinstalling XAMPP, you can get MySQL up and running in XAMPP in no time. This will open up a comand line and return more detailed errors about why apache can't run. e Error: MyS Jan 27, 2024 · If you are facing the error MySQL not working in Xampp Windows 11, It means mysql port 3306 is already used by a another application in your windows system, How to fix MySQL server not starting in the XAMPP control panel. Mostly, be looking for syntax errors that you could've created by editing your httpd. And try again. exe --defaults-file=c:\xampp\mysql\bin\my. Stop all the running services. conf, or httpd-ssl. I had a problem with mysql in xampp so i decided to reinstall xampp. Feb 10, 2015 · Thanks. If mysqld is currently running, you can find out what path settings it is using by executing this command: Press CTRL+C to copy. port = 3307. /lampp startmysql I get message: XAMPP: Couldn't start MySQL! I also tried wtih panel sudo . ini' file again and open with Notepad. That's why we need to stop the already installed one so that the XAMPP's one start working. 16:27:46 [main] Starting Check-Timer. I deleted my old mysql using "sc delete mysql" and did not delete my stored data then after that, I went into xampp and deleted the mysql from module service and reinstall it. – TomSawyer. Mar 5, 2020 · 1. Restart your Xampp server. Stop the instance of the mysql and apache before starting the XAMPP mysql and apache. /lampp panel There it says that Apache and PROFTPD are both running but Today in this video I am going to step by step guide you on How to fix Xampp MySQL Shutdown Unexpectedly or Xampp MySQL not starting. 3-5) is compatible with OS X Yosemite. SOLUTION: This is how i fixed this problem. When I click on "Start" in the Control Panel, I get a short flash of the PID and Port 3306 before it shuts down again. msc. Click on the "Shell" button next to the MySQL label. Jun 26, 2019 · When I try to start XAMPP - MySql it doesn't work. Onur Ozfuttu. Set "startup type" to "manual" then click on "apply" and "ok". \\mysql\\user’ is corr Apr 13, 2023 · Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. Right click on "Apache (version_num)" and then go to "properties". ini ". Or: Press CTRL+C to copy. Then launch taskmgr. answered Dec 25, 2021 at 5:27. Start Apache and MySQL Services. Actually that worked for me just fine. ). MYI , making sure to replace /path/to/your/table. Step:1 Run these two queries for the damaged table: REPAIR TABLE mysql. 4) Kill the process using. sudo /opt/lampp/lampp start Apr 15, 2016 · Restart Mysql service manually from services. al rk bj jl al va pc ei kc gk