Date: Sat, 09 Jan 2010 09:56:36 +0000 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: jaymax <jaymax36@gmail.com> Cc: freebsd-questions@freebsd.org Subject: Re: mySQL 5.4 server & Post installation SNAFUs Message-ID: <4B4852D4.90002@infracaninophile.co.uk> In-Reply-To: <27086064.post@talk.nabble.com> References: <27086064.post@talk.nabble.com>
index | next in thread | previous in thread | raw e-mail
[-- Attachment #1 --]
jaymax wrote:
> Post installation SNAFUS
> ========================
> [i] support-files/mysql.server are apparently in "/usr/local/share/mysql" am
> I correct, all of them?
Yes, except that mysql-server is the rc.subr(8) script to start up mysql on
boot, and that is to be found in /usr/local/etc/rc.d/mysql-server
> [ii] mysql_secure_installation is not found in this installation, it is in
> v. 5.5 however.
It's part of a different port. You need to install databases/mysql54-scripts
The same applies to mysql55 actually -- you must have somehow already
installed databases/mysql55-scripts in that case.
> [iii] Start restricted to /usr/local/bin/mysqld_safe & apparently since
> mysql_secure_installation is not available
>
> [iv] /usr/local/bin/mysqladmin -u root password ==>
> ax# /usr/local/bin/mysqladmin -u root password 'xxxxxxxx'
> /usr/local/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'root'@'localhost' (using password: NO)'
> ax# /usr/local/bin/mysqladmin -u root -h ax.lall.com password xxxxxxxx
> /usr/local/bin/mysqladmin: connect to server at 'ax.lall.com' failed
> error: 'Access denied for user 'root'@'ax.lall.com' (using password: NO)'
> HOW can I setup root password ?
If you're currently logged into ax.lall.com, then you definitely want
to use '-h localhost' (or nothing, as that's the default). If there is
already a root password, obviously you need to give it. Conversely, if
you've got a password set in /root/.my.cnf or some other my.cnf file but
this is a brand new mysql install with no root password yet, then you need
to temporarily move that file aside: mysql doesn't let you in if you try
and supply a password for a no-password account.
I advise using mysql_secure_installation -- but you're still going to have
to move aside any pre-existing .my.cnf files. Also, as a general security
thing, preferably don't allow root logins to mysql from anywhere other than
localhost.
Cheers,
Matthew
--
Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard
Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate
Kent, CT11 9PW
[-- Attachment #2 --]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEAREIAAYFAktIUtoACgkQ8Mjk52CukIy9bwCgkhE/NotXK4vWX9s3/BTa3Die
sy0An32y0LkPLKTyI+DVGqJynUibDrAo
=NfhM
-----END PGP SIGNATURE-----
help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4B4852D4.90002>