Go Back   DaemonForums > FreeBSD > FreeBSD Ports and Packages

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

Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   (View Single Post)  
Old 24th May 2008
dctr dctr is offline
Port Guard
Join Date: May 2008
Posts: 30
Default mySql problems

I installed Apache22, php5, php5-extensions, phpmyadmin and mysql mainly for the purpose of snort / snortreport.

Installing MySQL:

1. Go to the mysql50-server port directory by typing the command:

cd /usr/ports/databases/mysql50-server

2. Build the port by typing: (This takes AGES - good time for some food.)


3. Install by typing:

make install clean

4. Open /etc/rc.conf with your favourite text editor and add the line shown below. This will ensure mysql is enabled and starts on boot.


5. Start mysql manually to avoid having to reboot now by typing:

/usr/local/etc/rc.d/mysql-server start

6. Set a password for the MySQL root user by executing the command, subtituting your own password in place of new-password:

/usr/local/bin/mysqladmin -uroot password 'new-password'

And you're done! MySQL is installed.
Everything works fine, UNTIL
/usr/local/bin/mysqladmin -uroot password 'new-password
I'll get error

r00tr00t# /usr/local/bin/mysqladmin -uroot password newpassword
/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
when i change it up.

r00tr00t# /usr/local/bin/mysqladmin -u root -p password
Enter password:
/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
other times i get using password: NO

I don't know what my problem is, do you?

Last edited by dctr; 24th May 2008 at 10:26 AM.
Reply With Quote

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
MySQL problems in FBSD 6.2 Mantazz FreeBSD Ports and Packages 8 3rd November 2009 09:55 AM
MYSQL 's fault? disappearedng FreeBSD General 3 14th October 2008 11:53 PM
problems installing mysql port dejabu18 FreeBSD Ports and Packages 22 7th August 2008 09:23 AM
mysql on freebsd 7 nijikon FreeBSD General 0 20th May 2008 12:47 PM
mysql using >100% cpu bdj FreeBSD General 5 16th May 2008 04:20 PM

All times are GMT. The time now is 04:09 PM.

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