Xampp Installation - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24) +--- Thread: Xampp Installation (/showthread.php?tid=66283) |
Xampp Installation - davy_yg - 10-03-2016 Hello, I have this xampp installation: Status change detected: running 8:21:06 PM [mysql] Status change detected: stopped 8:21:06 PM [mysql] Error: MySQL shutdown unexpectedly. 8:21:06 PM [mysql] This may be due to a blocked port, missing dependencies, 8:21:06 PM [mysql] improper privileges, a crash, or a shutdown by another method. 8:21:06 PM [mysql] Press the Logs button to view error logs and check 8:21:06 PM [mysql] the Windows Event Viewer for more clues 8:21:06 PM [mysql] If you need more help, copy and post this 8:21:06 PM [mysql] entire log window on the forums It does not work well after the installation only for a short period of time. Now I am trying to fix the error can anyone help me how to? Thanks in advance. RE: Xampp Installation - InsiteFX - 10-03-2016 How to fix Error: MySQL shutdown unexpectedly on Xampp You do know how to search using Google right? RE: Xampp Installation - davy_yg - 10-04-2016 I have tried google and it still have some problem by trying this: Step 1: you must turn off the xampp application. step 2: the you the link "xampp \ mysql \ bin" folder and click on the "my.ini" Step 3: Next to repair: # Password = your_password port = 3306 becomes 3307 socket = "C: /xampp/mysql/mysql.sock" and # The MySQL server [Mysqld] port = 3306 becomes 3307 socket = "C: /xampp/mysql/mysql.sock" ------------------------------------------- I already try several other things that does not works well. I need some other suggestion to fix this problem. RE: Xampp Installation - InsiteFX - 10-05-2016 This is how you reset and change the XAMPP MySQL password. Save the 2 files below to a directory. mysql-init.txt Code: UPDATE mysql.user SET Password=PASSWORD('Your-New-Password') WHERE User='root'; Edit this file and add your User and Password. Then Copy this file to: C:\xampp\mysql\mysql-init mysql-start.txt Code: C:\xampp\mysql\bin\mysqld --init-file=C:\xampp\mysql\mysql-init.txt Run mysql-start.txt from a Windows Command prompt. NOTE: If that will not work you may need to do the below. In case if you have Xampp installed. 1) Goto C:\xampp\mysql\bin 2) Open my.ini file 3) Put skip-grant-tables under [mysqld] 4) Goto windows services and stop mysql service Trigger this command from command prompt C:\xampp\mysql\bin\mysql Now, reset the root password with the MySQL query update mysql.user set password=PASSWORD('Password') where user='root'; Exit the command prompt. Restart the mysql windows service that was turned off in step 4. Now you will be able to login to mysql using password as root. C:\xampp\mysql\bin\mysql \g update mysql.user set password=PASSWORD('Password') where user='root'; RE: Xampp Installation - rtenny - 10-05-2016 (10-05-2016, 03:13 AM)InsiteFX Wrote: This is how you reset and change the XAMPP MySQL password. No offence, but the xampp forum is the place to go, this has nothing to do with CI I dont mind helping people on CI but I think your are in the wrong place for this questions. RE: Xampp Installation - davy_yg - 10-06-2016 Hello, I don't think my xampp works well. I use another alternative like: Ampps Ampps/phpMyAdmin/config.inc.php PHP Code: $cfg['Servers'][$i]['verbose'] = ''; The result: http://localhost/phpmyadmin/ Welcome to phpMyAdmin Wrong username/password. Access denied. |