Starting httpd: (98)Address already in use: make_sock: could not bind to address [::]:80 + httpd wont start

While trying to restart httpd: /etc/init.d/httpd start Having the error: [wpfmb type=’error’ theme=2]Starting httpd: (98)Address already in use: make_sock: could not bind to address [::]:80 (98)Address already in use: make_sock: could not bind to address 0.0.0.0:80 no listening sockets available, shutting down Unable to open logs [FAILED][/wpfmb] To resolve this error run: fuser -k -n tcp […]

Continue Reading…

Httpd wont start in direct admin and gives the error

While trying to start httpd in direct admin giving the following error: # /etc/init.d/httpd start [wpfmb type=’error’ theme=2]Starting httpd: Syntax error on line 30 of /usr/local/directadmin/data/users/clickalist/httpd.conf:Invalid command ‘php_admin_flag’, perhaps misspelled or defined by a module not included in the server configuration[/wpfmb] To resolve this error follow the steps below: ./build update Backup any file named […]

Continue Reading…

ERROR 1153 (08S01) at line 16985: Got a packet bigger than ‘max_allowed_packet’ bytes

While trying to restore a MySQL database I was getting the following error: [wpfmb type=’error’ theme=2]root@server [/var/lib/mysql]# mysql a24uall_data </home/username/dbuploaded.sql ERROR 1153 (08S01) at line 16985: Got a packet bigger than ‘max_allowed_packet’ bytes[/wpfmb] To resolve this error: In my.cnf file add the following line : set-variable = max_allowed_packet=32M And restart MySQL : /etc/init.d/mysql restart […]

Continue Reading…

Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) [2002]

Sometime get the following error on MySQL sites and also when trying to access MySQL from server: [wpfmb type=’error’ theme=2]Can’t connect to local MySQL server through socket‘/var/lib/mysql/mysql.sock’ (2) [2002][/wpfmb] Solution is very simple: /etc/my.cnf skip-innodb Try to restart MySQL and if it don’t start then use: killall -9 mysqld Assign appropriate permissions to your /tmp directory. # […]

Continue Reading…

How to reset MySQL root password in linux centos

To Reset your MySQL root password: /etc/init.d/mysqld stop mysql -u root Use mysql; update user set password=(“YOUR_ROOT_PW”) where User=’root’; or /usr/bin/mysqladmin -u root password ‘yourmysqlpassword’ Above command can be used to reset plesk admin password as well. flush privileges; quit /etc/init.d/mysqld stop /etc/init.d/mysqld start mysql -u root -p Done. If you want to reset MySQL […]

Continue Reading…