Bug 249114

Summary:	emerge --config =dev-db/mysql-5.0.70 returns 'root'@'localhost' (using password: NO)
Product:	Gentoo Linux	Reporter:	orangeluna <orangeluna>
Component:	Current packages	Assignee:	Gentoo Linux bug wranglers <bug-wranglers>
Status:	RESOLVED INVALID
Severity:	normal
Priority:	High
Version:	unspecified
Hardware:	All
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---

Description orangeluna 2008-11-27 21:20:56 UTC

When loading a configured snort (/etc/init.d/.snort start) mysql database returns:

'root'@'localhost' (using password: NO)

No configuring I could load snort errorless.

I followed the wiki http://www.gentoo-wiki.info/Snort.  Tofix the problem I had to erase mysql:

      /etc/init.d/mysql stop
      rc-update del mysql
      emerge -C mysql
      rm -r /etc/mysql
      rm -r /var/lib/mysql
      rm -r /var/run/mysqld
      rm -r /var/log/mysql

emerge mysql again

Install Database:

/usr/bin/mysql_install_db
/etc/init.d/mysql start
/usr/bin/mysqladmin -u root password 'password'

Then I added user and database and restarted snort and didn't get the (using password: NO) error.

Reproducible: Always

Comment 1 Jeroen Roovers (RETIRED) gentoo-dev

2008-11-27 23:37:35 UTC

Gentoo isn't responsible for http://www.gentoo-wiki.info/

Comment 2 orangeluna 2008-11-29 18:55:43 UTC

Agreed.  I tried the "emerge --config =dev-db/mysql..." twice though and got this error.  When I used the "/usr/bin/mysql_install_db" script I didn't have a problem.  Am new to mysql, possible error on my part.