CodeIgniter Forums

Full Version: Xampp Installation
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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.
How to fix Error: MySQL shutdown unexpectedly on Xampp

You do know how to search using Google right?
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.
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';
FLUSH PRIVILEGES;

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';
(10-05-2016, 03:13 AM)InsiteFX Wrote: [ -> ]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';
FLUSH PRIVILEGES;

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';

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.
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'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = file_get_contents('../ampps/data/my.conf');
$cfg['Servers'][$i]['hide_db'] = '(mysql|information_schema|performance_schema)';
$cfg['Servers'][$i]['AllowNoPassword'] = true

The result:

http://localhost/phpmyadmin/


Welcome to phpMyAdmin

[Image: dot.gif]Wrong username/password. Access denied.