Full Disclosure mailing list archives
RE: MySQL and the user "su"
From: Tom Crimmins <seclists () pottcounty com>
Date: Fri, 31 Dec 2004 10:42:27 -0600
[snip] I have today determined that I can connect to a local MySQL-server per "mysql -usu". I regard that to error, can that someone confirm? [/snip] This is not an error. You should by default be able to connect with any user from localhost, but you will not have privileges to do anything else. This is because the mysql install by default sets up permissions this way. You could verify this yourself by connecting as root, and executing the following query: SELECT * FROM mysql.user; The row that applies in this case is the one with Host='localhost' and User=''. You can delete this row if you do not want this behavior. You must do a "flush privileges;" after deleting the row. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa _______________________________________________ Full-Disclosure - We believe in it. Charter: http://lists.netsys.com/full-disclosure-charter.html
Current thread:
- RE: MySQL and the user "su" Tom Crimmins (Jan 01)
- <Possible follow-ups>
- RE: MySQL and the user "su" Tom Crimmins (Jan 03)
- MySQL and the user "su" Sascha Wolf (Jan 06)
- Re: MySQL and the user "su" Andrew Farmer (Jan 02)
- Re: MySQL and the user "su" Kristian Koehntopp (Jan 06)
- Re: MySQL and the user "su" Sascha Wolf (Jan 06)