LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-08-2008, 05:31 PM   #16
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,520

Rep: Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502

You can use this my.cnf
Could you tell us how have you installed mysql and what steps you've followed for post-installation?
 
Old 10-09-2008, 07:24 AM   #17
leicaphotos
Member
 
Registered: Oct 2008
Posts: 68

Original Poster
Rep: Reputation: 15
I followed the instructions found here:
http://www.freebsdmadeeasy.com/tutor...on-freebsd.php
 
Old 10-09-2008, 07:57 AM   #18
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,520

Rep: Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502
Well, the howto you've followed is for mysql-4.1, but the error you get about running mysql_upgrade I think it's from mysql versions >5.
Can you run:
Code:
mysdlq -V       (to find the version)
mysqld-debug --user=mysql
mysqld --print-defaults
to see if you get any useful info.

Last edited by bathory; 10-09-2008 at 07:58 AM.
 
Old 10-09-2008, 08:02 AM   #19
leicaphotos
Member
 
Registered: Oct 2008
Posts: 68

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by bathory View Post
Well, the howto you've followed is for mysql-4.1, but the error you get about running mysql_upgrade I think it's from mysql versions >5.
Can you run:
Code:
mysdlq -V       (to find the version)
mysqld-debug --user=mysql
mysqld --print-defaults
to see if you get any useful info.
yes, but I still went to the latest area for the build ---

pcbsd# mysdlq -V
mysdlq: Command not found.

this is frustrating as I know i'm almost fixed on my server and once it's running right, there'll be very few problems

am running ===> Installing for mysql-server-6.0.6 (pulled straight from the install log)
 
Old 10-09-2008, 08:30 AM   #20
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,520

Rep: Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502
Quote:
mysdlq -V
mysdlq: Command not found.
That means that mysqld is not in your path. Look for the correct location and run the other commands from there.
Quote:
am running ===> Installing for mysql-server-6.0.6 (pulled straight from the install log)
mysql-server-6.0.6 is still alpha, so it's not strange that it's not running on your system. Try mysql-5.0.x that is stable or at least mysql-5.1.x
 
Old 10-09-2008, 09:05 AM   #21
leicaphotos
Member
 
Registered: Oct 2008
Posts: 68

Original Poster
Rep: Reputation: 15
am in the process of removing 6.* and retro installing 5.1 -- will keep you posted - thanks for all the help
 
Old 10-10-2008, 08:27 AM   #22
leicaphotos
Member
 
Registered: Oct 2008
Posts: 68

Original Poster
Rep: Reputation: 15
ok, new set of problems - am very frustrated with this...


I removed the 6.0* and went with the 5.*

here are my logs from term

pcbsd# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck'...
mysqlcheck: Got error: 2002: Can't connect tolocal MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed


AND from the .err file:

081008 06:21:45 mysqld_safe Starting mysqld da
emon with databases from /var/db/mysql
081008 6:21:45 [Warning] Ignoring user change
to 'ser=mysql' because the user was set to 'm
ysql' earlier on the command line

081008 6:21:45 [ERROR] Can't open the mysql.p
lugin table. Please run mysql_upgrade to creat
e it.
081008 06:22:32 mysqld_safe Starting mysqld da
emon with databases from /var/db/mysql
081008 6:22:32 [Warning] Ignoring user change
to 'ser=mysql' because the user was set to 'm
ysql' earlier on the command line

081008 6:22:32 [ERROR] Can't open the mysql.p
lugin table. Please run mysql_upgrade to creat
e it.
081010 07:01:46 mysqld_safe Starting mysqld da
emon with databases from /var/db/mysql
/usr/local/libexec/mysqld: Table 'mysql.plugin
' doesn't exist
081010 7:01:46 [ERROR] Can't open the mysql.p
lugin table. Please run mysql_upgrade to creat
e it.
InnoDB: The first specified data file ./ibdata
1 did not exist:
InnoDB: a new database to be created!
081010 7:01:46 InnoDB: Setting file ./ibdata
1 size to 10 MB
InnoDB: Database physically writes the file fu
ll: wait...
081010 7:01:46 InnoDB: Log file ./ib_logfile
0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to
5 MB
InnoDB: Database physically writes the file fu
Interrupted


so, now I've created a my.cnf file - maybe something is not right - I used the example referenced earlier in the thread...

just trying to get the mysql working today
 
Old 10-10-2008, 08:53 AM   #23
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,520

Rep: Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502
So actually you have the same problem as in mysql 6.0.
Maybe the installation you're following does not run the mysql_install_db that is necessary before running the server for the first time. Look for the script and try to run it manually to see if it works:
./mysql_install_db --user mysql
Maybe you should consider using the mysql binary for FreeBSD from mysql.
 
Old 10-10-2008, 10:24 AM   #24
leicaphotos
Member
 
Registered: Oct 2008
Posts: 68

Original Poster
Rep: Reputation: 15
ok, I've downloaded the file directly from mysql --- where do I extract the contents and what do I do next? Sorry for all the questions, but this is new territory
 
Old 10-10-2008, 10:35 AM   #25
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,520

Rep: Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502
You can extract it where you want. Just make sure to create the symlink from mysql-xyz-whatever to mysql
It' all written in INSTALL-BINARY. Just follow the instructions and if you have any problems post back here.
 
Old 10-10-2008, 11:22 AM   #26
leicaphotos
Member
 
Registered: Oct 2008
Posts: 68

Original Poster
Rep: Reputation: 15
hot damn, thank you so much -- now everything seems to be working -- thank you for your tireless help
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 09-17-2014 03:13 PM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Software 3 06-28-2007 12:46 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 04:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM


All times are GMT -5. The time now is 10:13 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration