LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
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 07-15-2006, 03:02 AM   #31
MrSako
Member
 
Registered: May 2006
Distribution: CentOS 4.4
Posts: 185

Original Poster
Rep: Reputation: 30

ooooooooooooooooooooooooooooo i figured out what i was doing wrong, i wasnt really in the right directory

i did ./configure and it said

Quote:
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you. If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h vps.mydomain.com password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
Starting the mysqld server. You can test that it is up and running
with the command:
./bin/mysqladmin version
Starting mysqld daemon with databases from /home/mysql/mysql-standard-5.0.22-linux-i686/data
STOPPING server from pid file /home/mysql/mysql-standard-5.0.22-linux-i686/data/vps.mydomain.com.pid
060715 03:10:22 mysqld ended
so it turns out its a binary. so i dont know what to do now

Last edited by MrSako; 11-08-2006 at 04:35 PM.
 
Old 07-15-2006, 06:21 AM   #32
jstephens84
Senior Member
 
Registered: Sep 2004
Distribution: (Home)Opensolaris, Ubuntu, CentOS, (Work - AIX, HP-UX, Red Hat)
Posts: 2,056

Rep: Reputation: 94
Ok here we go.
Code:
groupadd mysql
useradd -g mysql mysql
cd /usr/local
tar -zxvf < /path/to/mysql-VERSION-OS.tar.gz 
cp mysql-version-OS.tar.gz /usr/local/mysql
cd /usr/local/mysql
scripts/mysql_install_db --user=mysql
chown -R root  .
chown -R mysql data
chgrp -R mysql .
bin/mysqld_safe --user=mysql &
this should get you going. Now this will be different due to the information will now be in /usr/local/mysql. Databases will not be in /var. However you can work around this and get your databases there but That is beyond me. It normally takes me sitting in front of the screen to do this. Any problems let me know.
 
Old 07-15-2006, 02:22 PM   #33
MrSako
Member
 
Registered: May 2006
Distribution: CentOS 4.4
Posts: 185

Original Poster
Rep: Reputation: 30
when i typed in the scripts/mysql_install_db part i got a bunch of this

Quote:
> scripts/mysql_install_db --user=mysql
Installing all prepared tables
Fill help tables
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_topic.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_keyword.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_relation.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
060715 14:21:33 [ERROR] ./bin/mysqld: Can't find file: './mysql/help_category.frm' (errno: 13)
and went over and on with a whole bunch of help related files with frm extensions but at the very bottom it prints out

Quote:
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h vps.mydomain.com password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
im going ot keep fallowing the instructions but i just didnt expect that

also is this normal?

Quote:
> bin/mysqld_safe --user=mysql &
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/vps.mydomain.com.pid
060715 14:26:16 mysqld ended

Last edited by MrSako; 11-08-2006 at 04:35 PM.
 
Old 07-15-2006, 02:35 PM   #34
jstephens84
Senior Member
 
Registered: Sep 2004
Distribution: (Home)Opensolaris, Ubuntu, CentOS, (Work - AIX, HP-UX, Red Hat)
Posts: 2,056

Rep: Reputation: 94
Could you post your my.cnf file.
 
Old 07-15-2006, 05:31 PM   #35
MrSako
Member
 
Registered: May 2006
Distribution: CentOS 4.4
Posts: 185

Original Poster
Rep: Reputation: 30
i looked around for it, but i dont see where my "my.cnf" file is
 
Old 07-15-2006, 05:52 PM   #36
jstephens84
Senior Member
 
Registered: Sep 2004
Distribution: (Home)Opensolaris, Ubuntu, CentOS, (Work - AIX, HP-UX, Red Hat)
Posts: 2,056

Rep: Reputation: 94
It should either be in /usr/local/mysql or /etc. It also maybe that you have to rename something like my-huge.cnf or my-small.cnf to my.cnf or my.conf. Can't remember off the top of my head.
 
Old 07-15-2006, 06:25 PM   #37
MrSako
Member
 
Registered: May 2006
Distribution: CentOS 4.4
Posts: 185

Original Poster
Rep: Reputation: 30
i found the cnf files you were talking about,

/usr/local/mysql/mysql-test/std_data/ndb_config_mycnf1.cnf
/usr/local/mysql/mysql-test/std_data/ndb_config_mycnf1.cnf
/usr/local/mysql/support-files/my-huge.cnf
/usr/local/mysql/support-files/my-innodb-heavy-4G.cnf
/usr/local/mysql/support-files/my-large.cnf
/usr/local/mysql/support-files/my-medium.cnf
/usr/local/mysql/support-files/my-small.cnf

what are the differences between them? and where do i place the one i want?
 
Old 07-15-2006, 06:37 PM   #38
jstephens84
Senior Member
 
Registered: Sep 2004
Distribution: (Home)Opensolaris, Ubuntu, CentOS, (Work - AIX, HP-UX, Red Hat)
Posts: 2,056

Rep: Reputation: 94
This depends on how this machine will be used. If it is for development purposes then You may just want to go with my-small.cnf. If you are using this in a production environment then you may want to choose medium - huge. The difference is how much the optimization of each of them.

You will need to copy them probably to either /etc or /usr/local/mysql. I am probably going to say copy them to /etc. Then try to run mysql_install_db --user=mysql again. I am currently installing CentOS 4.3 on a test server at my house so once it finishes I will be able to get a better look at what is going on.
 
Old 07-15-2006, 09:56 PM   #39
MrSako
Member
 
Registered: May 2006
Distribution: CentOS 4.4
Posts: 185

Original Poster
Rep: Reputation: 30
i try putting it in /usr/local/mysql and /etc each time it did the same thing

> bin/mysqld_safe --user=mysql &
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/vps.myfomain.com.pid
060715 21:57:14 mysqld ended

Last edited by MrSako; 11-08-2006 at 04:36 PM.
 
Old 07-16-2006, 01:50 AM   #40
jstephens84
Senior Member
 
Registered: Sep 2004
Distribution: (Home)Opensolaris, Ubuntu, CentOS, (Work - AIX, HP-UX, Red Hat)
Posts: 2,056

Rep: Reputation: 94
can you post the my.cnf file that is used? I think I came acrossed this error before.
 
Old 07-16-2006, 01:49 PM   #41
MrSako
Member
 
Registered: May 2006
Distribution: CentOS 4.4
Posts: 185

Original Poster
Rep: Reputation: 30
this is my.cnf which currently resides in /usr/local/mysql/my.cnf

http://rafb.net/paste/results/PVaFHx57.html
 
Old 07-16-2006, 02:45 PM   #42
jstephens84
Senior Member
 
Registered: Sep 2004
Distribution: (Home)Opensolaris, Ubuntu, CentOS, (Work - AIX, HP-UX, Red Hat)
Posts: 2,056

Rep: Reputation: 94
What are the permissions for /usr/local/mysql/data. Is mysql the owner and the group for that directory. If not then do the following to change the permissions on the folder.
Code:
chown -R /usr/local/mysql/data mysql
chgrp -R /usr/local/mysql/data mysql
the issue a mysql_install_db --user=mysql
 
Old 07-16-2006, 03:06 PM   #43
MrSako
Member
 
Registered: May 2006
Distribution: CentOS 4.4
Posts: 185

Original Poster
Rep: Reputation: 30
> chown -R /usr/local/mysql/data mysql
chown: `/usr/local/mysql/data': invalid user

but i did create the mysql user....
 
Old 07-16-2006, 04:36 PM   #44
MrSako
Member
 
Registered: May 2006
Distribution: CentOS 4.4
Posts: 185

Original Poster
Rep: Reputation: 30
nevermind it seems it was just the wrong syntax
> chown -R mysql:mysql /usr/local/mysql/data
> chgrp -R mysql /usr/local/mysql/data
> mysql_install_db --user=mysql
bash: mysql_install_db: command not found


thats what i just did

i also did this again no luck

> bin/mysqld_safe --user=mysql &
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/vps.mydomain.com.pid
060716 16:39:27 mysqld ended

Last edited by MrSako; 11-08-2006 at 04:36 PM.
 
Old 07-16-2006, 05:26 PM   #45
MrSako
Member
 
Registered: May 2006
Distribution: CentOS 4.4
Posts: 185

Original Poster
Rep: Reputation: 30
ok i got mysql to start!!!!

idunno how but its running but unfourtnatly i still get this in my httpd error log

[client 24.163.113.48] PHP Fatal error: Call to undefined function mysql_connect() in /var/www/html/phpinfo.php on line 8
 
  


Reply

Tags
apache, apache2, lamp, php, php5


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
A terrible trauble about linux + apache + php + mysql jiawj Linux - Software 2 06-03-2006 07:39 AM
Linux + Apache + PHP + ??MySQL/PostgreSQL?? Thakowbbery Linux - Enterprise 4 10-28-2005 04:18 PM
Linux, Apache, PHP, MySQL akilles Linux - Newbie 4 03-02-2005 03:43 AM
Linux 8.0 installed with Apache 2.0, PHP and MySQL fmagoufis Linux - Newbie 1 12-12-2002 02:13 PM
VMWare, RH Linux 7.3, Apache, MySQL and PHP xibernex Linux - Software 2 06-17-2002 10:57 AM


All times are GMT -5. The time now is 03:58 PM.

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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration