DaemonForums  

Go Back   DaemonForums > OpenBSD > OpenBSD Packages and Ports

OpenBSD Packages and Ports Installation and upgrading of packages and ports on OpenBSD.

Reply
 
Thread Tools Display Modes
  #1   (View Single Post)  
Old 6th February 2011
erehwon erehwon is offline
Port Guard
 
Join Date: May 2008
Location: Cascadia
Posts: 34
Thanked 0 Times in 0 Posts
Default Hell of a time with MySQL

I'm following the directions but no matter what I do, even after uninstalling/reinstalling, MySQL continues to error as follows:

Code:
# /usr/local/bin/mysql_install_db
Installing MySQL system tables...
OK
Filling help tables...
OK

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h nedra.belgar.ath.cx password 'new-password'

Alternatively you can run:
/usr/local/bin/mysql_secure_installation
My root password here is NOT the system root account, I hope? But even then, I tried it, to no avail:

Code:
# /usr/local/bin/mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Stumped, completely stumped here. Help? Yes, I have removed the user and group _mysql after each try for reinstallation, etc. Is there some other login or passwd file that is not getting refreshed even upon uninstall/reinstall?
Reply With Quote
  #2   (View Single Post)  
Old 6th February 2011
erehwon erehwon is offline
Port Guard
 
Join Date: May 2008
Location: Cascadia
Posts: 34
Thanked 0 Times in 0 Posts
Default

Nevermind. For whatever reason, an old password was required that is not currently any password I use, but thanks to memory...
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hell has frozen over Mr-Biscuit Off-Topic 2 6th November 2010 03:09 PM
Time for a New Laptop harold FreeBSD General 4 5th October 2009 05:56 AM
NFS time outs trilog General software and network 1 5th May 2009 07:21 AM
Real Time OS corey_james Off-Topic 2 11th July 2008 02:56 PM
Time drift cajunman4life FreeBSD General 4 18th June 2008 07:21 AM


All times are GMT. The time now is 06:53 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content copyright © 2007-2010, the authors
Daemon image copyright ©1988, Marshall Kirk McKusick