DaemonForums  

Go Back   DaemonForums > FreeBSD > FreeBSD Ports and Packages

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

Reply
 
Thread Tools Display Modes
  #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.

Quote:
#
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.)

make BUILD_OPTIMIZED=yes BUILD_STATIC=yes

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.

mysql_enable="YES"

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
Quote:
/usr/local/bin/mysqladmin -uroot password 'new-password
I'll get error

Code:
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.

Code:
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
  #2   (View Single Post)  
Old 24th May 2008
cajunman4life cajunman4life is offline
Real Name: Aaron Graves
Package Pilot
 
Join Date: May 2008
Location: Coolidge, Arizona
Posts: 203
Default

You can use the guide here:
http://dev.mysql.com/doc/refman/5.0/...rmissions.html

Or here:
http://dev.mysql.com/doc/refman/5.0/...rivileges.html

But the default root account on MySQL should not have a password. So you can connect simply by "mysql -u root"

Let us know if either of the above are helpful or work for you.
__________________
I just saved a bunch of money on my car insurance by fleeing the scene of the accident!
Reply With Quote
  #3   (View Single Post)  
Old 25th May 2008
dctr dctr is offline
Port Guard
 
Join Date: May 2008
Posts: 30
Default

Thank you! worked perfect.
Reply With Quote
  #4   (View Single Post)  
Old 25th May 2008
cajunman4life cajunman4life is offline
Real Name: Aaron Graves
Package Pilot
 
Join Date: May 2008
Location: Coolidge, Arizona
Posts: 203
Default

Glad to help

It's been long enough since I've installed a fresh MySQL that I had to go in search myself.
__________________
I just saved a bunch of money on my car insurance by fleeing the scene of the accident!
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
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 05:57 AM.


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