[Sussex] Setting up MySQL under FC6

[Matthew Macdonald-Wallace]

Brendan,

Please run the following command as root then paste it into your reply:

tail -n 50 /var/log/mysql.log

Cheers,

Matt.

On Tue, 29 May 2007 15:37:43 +0100, "Brendan Whelan" <b_whelan at mistral.co.uk> wrote:
> Matt, thanks for the response.
> I have changed the hosts file and stopped/restarted MySQL - I then tried
> mysql -u root -p
> and was prompted for the password but when I entered the word I get 1045
> Access denied for user.
> Any suggestions?
> 
> Brendan
> ----- Original Message -----
> From: "Matthew Macdonald-Wallace" <matthew at truthisfreedom.org.uk>
> To: "LUG email list for the Sussex Counties" <sussex at mailman.lug.org.uk>
> Sent: Tuesday, May 29, 2007 2:33 PM
> Subject: Re: [Sussex] Setting up MySQL under FC6
> 
> 
> 
> On Tue, 29 May 2007 14:09:17 +0100, "Brendan Whelan"
> <b_whelan at mistral.co.uk> wrote:
>> Hello,
>>
>> I have a new installation of Fedora Core 6 and, as ever, there are a few
>> changes from earlier versions to the likes of MySQL.
>> I installed FC6 and then installed MySQL and configured the network. I
>> also set the MySQL password.
>>
>> service mysqld start          works fine
>>
>> But when I try to connect with
>> mysql -u root
>> or
>> mysql -u root -pmypassword
>>
>> I get a failure message 1045 Access denied for user
>>
>> I have tried re-installing the MySQL and searched the Internet there are
>> some suggestions that it could be a problem with /etc/hosts.
>> My hosts file has one working line
>> ::1 my_machine_name localhost.localdomain localhost 127.0.0.1
>>
>> I have tried starting mysql with skip-grant-tables but I don't seem to
>> have the precise syntax.
>>
>> Any suggestions?
>>
>> Thanks,  Brendan
> 
> edit the line in /etc/hosts to show:
> 
> 127.0.0.1 my_machine_name localhost.localdomain localhost
> ::1 my_machine_name localhost.localdomain localhost
> 
> Basically, your machine is quite possibly being thrown by IPv6 (mine does
> all the time!) so until you are using an IPv6 network, I suggest that you
> make sure that any ip addresses are IPv4.
> 
> Also, try:
> 
> mysql -u root -p
> 
> and then type your password when prompted.
> 
> HTH,
> 
> Matt.
> 
> 
> __
> Sussex mailing list
> Sussex at mailman.lug.org.uk
> E-mail Address: sussex at mailman.lug.org.uk
> Sussex LUG Website: http://www.sussex.lug.org.uk/
> https://mailman.lug.org.uk/mailman/listinfo/sussex
> 
> 
> 
> 
> __
> Sussex mailing list
> Sussex at mailman.lug.org.uk
> E-mail Address: sussex at mailman.lug.org.uk
> Sussex LUG Website: http://www.sussex.lug.org.uk/
> https://mailman.lug.org.uk/mailman/listinfo/sussex