Mysql is killing me
when i try to configure snort from k menu-> services-> set & initialize snort everything is fine there when i go to web browser hxxp://localhost/base after first screen i choose mysql as database type, snort as database name, localhost as database host, root as database name and password which i configure earlier but when i submit this message comes
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 364
Database connection failed!
Please try again!
when i try to connect with mysql using mysql -u root -p this error message comes
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
I search Google to resolve this but enable to find the solution i tried every method to connect with mysql with user root but failed to do so its only connect with user mysql but i can't use any database or create new one using user mysql