LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 10-27-2004, 11:44 PM   #1
brokenflea
Member
 
Registered: Nov 2003
Distribution: Slackware 11.0, FreeBSD
Posts: 284

Rep: Reputation: 30
MYSQL Install Problem. Help!!


i'm trying to install mysql on my box and everytime i type in configure, this is what happens. i googled and search the docs on dev.mysql.com but i'm stuck in a rut.... can anyone tell me what i'm doing that's not working.. or am i going in a circle here ??

here's the output from the CLI:

./configure
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
041027 22:40:09 [Warning] Asked for 196608 thread stack, but got 126976
Fill help tables
041027 22:40:09 [Warning] Asked for 196608 thread stack, but got 126976

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 darkstar 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 https://order.mysql.com
Starting the mysqld server. You can test that it is up and running
with the command:
./bin/mysqladmin version
root@darkstar:/usr/local/mysql-standard-4.1.7-pc-linux-i686# Starting mysqld daemon with databases from /usr/local/mysql-standard-4.1.7-pc-linux-i686/data
STOPPING server from pid file /usr/local/mysql-standard-4.1.7-pc-linux-i686/data/darkstar.pid
041027 22:40:11 mysqld ended
 
Old 10-27-2004, 11:59 PM   #2
gbonvehi
Senior Member
 
Registered: Jun 2004
Location: Argentina (SR, LP)
Distribution: Slackware
Posts: 3,145

Rep: Reputation: 53
Does the databases exists?
If you use the Slackware package you've to create them (take a look at /etc/rc.d/rc.mysqld) and if you don't mysql daemon exits the same way as yours (so i guess that's the problem).
 
Old 11-04-2004, 01:39 AM   #3
gbdavidx
Member
 
Registered: Oct 2004
Location: Sac, Calif
Distribution: Slackware 10.0
Posts: 123

Rep: Reputation: 15
i get the same thing as he does and i dont see that rc.mysqld
 
Old 11-04-2004, 04:52 AM   #4
ShoCkwave
Member
 
Registered: Mar 2004
Location: Turkey
Distribution: Ubuntu
Posts: 38

Rep: Reputation: 15
I dont read what is written above but main mysql problem with all slackwares solved likes this.

When you are root type

su mysql

now u becamo the mysql user on the computer

then go to /usr/bin
and there type ./mysql_install_db

then type
exit and go back to your own account. Now mysql had installed properly and you wont get error messages when starting it.

Next time you restart your computer it will work properly.
 
Old 11-05-2004, 02:00 AM   #5
gbdavidx
Member
 
Registered: Oct 2004
Location: Sac, Calif
Distribution: Slackware 10.0
Posts: 123

Rep: Reputation: 15
Code:
root@beiler:/usr/bin# ./mysql_install_db
-bash: ./mysql_install_db: No such file or directory
 
Old 11-05-2004, 02:25 AM   #6
gbonvehi
Senior Member
 
Registered: Jun 2004
Location: Argentina (SR, LP)
Distribution: Slackware
Posts: 3,145

Rep: Reputation: 53
You've to become mysql user before running that command, type: su - mysql
then mysql_install_db
 
Old 11-06-2004, 02:07 AM   #7
gbdavidx
Member
 
Registered: Oct 2004
Location: Sac, Calif
Distribution: Slackware 10.0
Posts: 123

Rep: Reputation: 15
Ok this is what i got;

Code:
bash-2.05b# su - mysql
/dev/pts/1: Operation not permitted
mysql@beiler:~$ mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
041106  0:07:08 /usr/libexec/mysqld: Shutdown Complete


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:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h beiler password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/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 /usr/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 https://order.mysql.com

mysql@beiler:~$
Does that mean it worked?
 
Old 11-06-2004, 02:13 AM   #8
gbonvehi
Senior Member
 
Registered: Jun 2004
Location: Argentina (SR, LP)
Distribution: Slackware
Posts: 3,145

Rep: Reputation: 53
Yeap, now run: chmod +x /etc/rc.d/rc.mysqld to execute mysql on startup. And to start it manually: /etc/rc.d/rc.mysqld start
to stop: /etc/rc.d/rc.mysqld stop
 
Old 11-06-2004, 02:16 AM   #9
gbdavidx
Member
 
Registered: Oct 2004
Location: Sac, Calif
Distribution: Slackware 10.0
Posts: 123

Rep: Reputation: 15
Code:
mysql@beiler:~$ chmod + /etc/rc.d/rc.mysqld
chmod: changing permissions of `/etc/rc.d/rc.mysqld': Operation not permitted
how do i fix this?

Edit: and i get this:

Code:
mysql@beiler:~$ /etc/rc.d/rc.mysqld start
-su: /etc/rc.d/rc.mysqld: Permission denied

Last edited by gbdavidx; 11-06-2004 at 02:18 AM.
 
Old 11-06-2004, 02:22 AM   #10
gbonvehi
Senior Member
 
Registered: Jun 2004
Location: Argentina (SR, LP)
Distribution: Slackware
Posts: 3,145

Rep: Reputation: 53
You have to be root for those, the only command that's needed to run as mysql user is the mysql_install_db, the other ones are as root.
 
  


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
Bugzilla - MySQL - perl - DBD::mysql install problem Runningonair Linux - Software 8 10-12-2007 12:42 AM
MySql Install Problem BlackShadow Linux - Software 2 10-01-2004 03:51 PM
problem with mySQL install coolamit78 Linux - Software 7 04-23-2004 02:00 PM
MySQL mysql-3.23.56-1.9, rpm install problem jacsmith510 Linux - Newbie 3 09-19-2003 02:02 PM
MySql install problem PatC Linux - Newbie 1 07-02-2002 04:08 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 04:48 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
Open Source Consulting | Domain Registration