Mysql will not start in centos

How do I start myql? Log file below

ran command  /etc/init.d/mysqld start ( or restart)

MySQL Daemon failed to start.

[root@u153777777 ~]# /etc/init.d/mysqld restart
Stopping mysqld:                                           [  OK  ]
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]
[root@u157777777 ~]#


[root@u1555551 ~]# mysqladmin -u root -p status
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysq               l/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.s               ock' exists!

site errors

Unable to open PDO connection [wrapped: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
 
Mysql logs:


 [root@u5555551 ~]# tail -n 20 /var/log/mysqld.log
120324 08:05:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pi                                   d ended
120324 08:06:27 mysqld_safe Starting mysqld daemon with databases from /va                                   r/lib/mysql
120324  8:06:27 [Note] Plugin 'FEDERATED' is disabled.
120324  8:06:27 InnoDB: The InnoDB memory heap is disabled
120324  8:06:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120324  8:06:27 InnoDB: Compressed tables use zlib 1.2.3
120324  8:06:27 InnoDB: Using Linux native AIO
120324  8:06:27 InnoDB: Initializing buffer pool, size = 128.0M
120324  8:06:27 InnoDB: Completed initialization of buffer pool
120324  8:06:27 InnoDB: highest supported file format is Barracuda.
120324  8:06:27  InnoDB: Waiting for the background threads to start
120324  8:06:28 InnoDB: 1.1.6 started; log sequence number 63736076615
120324  8:06:28 /usr/libexec/mysqld: unknown variable 'set-variabl                                   e=local-infile=0'
120324  8:06:28 Aborting

120324  8:06:28  InnoDB: Starting shutdown...
120324  8:06:29  InnoDB: Shutdown completed; log sequence number 637360766                                   15
120324  8:06:29 [Note] /usr/libexec/mysqld: Shutdown complete

120324 08:06:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pi                                   d ended
webguy62Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

farzanjCommented:
what does this return to you?
nslookup localhost
0
jgiordanoCommented:
has this instance ever started?

try commenting out the  'set-variable=local-infile=0' in the my.cnf file and starting up.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
webguy62Author Commented:
re:farzan reply:

[root@u7777777771 ~]# nslookup localhost
Server:         10.255.255.4
Address:        10.255.255.4#53

Non-authoritative answer:
Name:   localhost
Address: 127.0.0.1
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

webguy62Author Commented:
re jgiordano reply

at top of config i have all this. should I comment all or can i remove? I have BU :)

 [mysqld]
set-variable=local-infile=0
local-infile=0
0
webguy62Author Commented:
oh and yes this has started before :)
0
jgiordanoCommented:
It looks you have the same variable 2x with the wrong syntax possibly.

I would comment out the line
set-variable=local-infile=0
0
webguy62Author Commented:
I removed al thsos  lines at top of my.cnf stopped and started mysql now al sites back online :)  thanks big time
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux

From novice to tech pro — start learning today.