Re: How to configure mysql server?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 2006-06-22 at 17:38 +0100, Timothy Murphy wrote:
> Tom Brown wrote:
> 
> >> [tim@alfred ~]$ mysql -u root
> >> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> >> password: NO)
> 
> > seems there is a MySQL root pwd set - in that case use
> > 
> > mysql -u root -pyourpasswordhere
> > 
> > or leave off the yourpasswordhere and it will prompt you for it when you
> > hit enter
> 
> I don't follow you.
> I haven't set the root password (or any password)
> and if it has been set I haven't the slightest idea what it is.
> 
> 

Odds are, it was set accidentally by yourself.  However, that is no
longer here nor there.

So try this:

service mysqld stop
cd /var/lib/
my mysql mysql.bak
mysql_install_db
service mysqld start

If that fails (I suspect it will), check the end of /var/log/messages
and look for mysql related selinux errors -- Based on your previous
output I suspect you probably have selinux set to enforcing. 

Turn it off with "setenforce 0" and try to start SQL once again.  If
that works then, either disable selinux permanently or use the output
from /var/log/messages to fix the files mysql_install_db created.

Daniel

-- 
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora Magazine]     [Fedora News]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [SSH]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux