After Linux installation XAMPP, the Apache server fails to start, and after startup, the solution to problems encountered by connecting to the SQL database

XAMPP installation, when we build the server, what problems will we encounter?
1. MySQL Database can be started, and Apache Web server cannot start?
Should be 80 port is occupied, then how to solve it? We can do this by finding out which 80 is occupied and shutting down the process as follows:

1 grep :2 tcp        0      00.0.  0.0:              0.0.  0.0:*               LISTEN      1716/apache2

Close the service,

1 sudo  2 * Stopping Web server apache2: Waiting. [OK]

successfully closed. Next, you can start Apache Web Server with a port of 80.

2, after successfully opening the Apache Web Server service, I want to debug MySQL, found that MySQL Database startup, but unable to open the connection SQL, and the following error occurred

1 [email protected]:/opt/lampp/var/mysql# mysql-u root-p232002 (HY000): Can'/var/run/mysqld/mysqld.sock'  (2)

At this point, I was wondering how to find out where Mysqld.sock was. Eventually not found, only found Mysql.sock located in

1 ls 2 Aria_log. 00000001  Bt.pid      ibdata1      multi-master.  Info  performance_schema  tc.log3Aria_log_control   Challenges  ib_logfile0  mysql              phpmyadmin          test4 bt.err             dvwa        ib_logfile1  mysql.sock         Security

OK, when we find mysql.sock, we right-click the Create link and rename it to mysqld. Sock and then right-cut the file,

and put it in the path showing the error prompt, that is, to/var/run/, if there is no Mysqld folder, you have to create a new, and put Mysqld.sock in.
So now there's the Mysqld.sock file, and here at/var/run/mysqld/mysqld.sock.
Now, we can run

1 [email protected]:/# mysql-u root-p231045 (28000  for ' Root '@'localhost' (using Password:yes)

Found or error, this is because before, can not find Mysqld.sock, thought is the wrong password, modified the/opt/lampp/etc/under the MY.CNF, the password changed back

The default your_name, in effect, is a blank password. The contents are as follows

1 # The following options would be passed to all MySQL clients [client] 2 # password    =your_name3 Port         = 33064 Socket       =/opt/lampp/var /mysql/MySQL. sock

Okay, run it again.

1 [email protected]:/# mysql-u root-p23Welcome to the MySQL monitor. Commands End With; or \g. 4 ID Panax Notoginseng 5 5.5. 5-10.1. 9-MariaDB Source distribution6 ... 7 mysql>

Successfully completed, MySQL connection.

Reference::
1.http://stackoverflow.com/questions/11990708/error-cant-connect-to-local-mysql-server-through-socket-var-run-mysqld-mysq

After Linux installation XAMPP, the Apache server fails to start, and after startup, the solution to problems encountered by connecting to the SQL database