I'm pretty new to the whole linux, mysql, php industry and was wondering if I could get a little help on the installation of mysql onto my linux box (redhat 6.1).
I'm trying to follow the tutorial for mysql and php but run into a couple problems with the installation of mysql 3.23.38. Everytime I run the command
% ./configure --prefix=/usr/local/mysql
My system will start the installation but stalls. I have to ctrl-c to get back to the prompt. When I check PID's I have 3 assigned to mysqld. From this point on I can't continue the installation since it can't find any of the commands (i.e. make).
Any help that you can give me would be grately appreciated. But please ask questions gently still a newbie.
Thanks in advance.
Well, first type: 'killall mysqld'. I'm not quite sure why you would have mysqld running if you just ran ./configure --prefix=/usr/local/mysql.
Can you paste what configure says before it stalls?
thanks for the help first off -
when i say stall i mean that it won't give back the prompt until i ctrl - c
even when i ran the killall mysqld it simply hangs at that command until i ctrl - c. i have double check to make sure that no other version is installed since i didn't do the orginial installation. is there something else that needs to be installed to make mysql work?
This is what I get:
# killall mysqld
# ./configure --prefix=usr/local/mysql
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
010525 8:39:39 ./bin/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 !
This is done with:
./bin/mysqladmin -u root -p password 'new-password'
./bin/mysqladmin -u root -h ebs.dakotamade.com -p 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/safe_mysqld &
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; run-all-tests
Please report any problems with the ./bin/mysqlbug script!
The latest information about MySQL is available on the web at
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:
# Starting mysqld daemon with databases from /usr/local/mysql-3.23.38-unknown-linux-gnu-sparc/data
# bin/mysqladmin -u root status
Uptime: 35 Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.029
So I guess it's ready to go, eh?
I just got done reading your post and I'm a little confused. I downloaded the binary distribution for linux i386 and tried the installation - i even followed the manual in creating the group mysql and the user mysql. I just get a hanging ./configure when I run the command. Even when I run the killall mysqld command the system hangs until I do a ctrl-c. Then everything is back to normal.
When you say the this is the binary distribution and you don't need to configure it - what are you talking about - does it comes preconfigured.
Thanks for the help
Actually, it's the script that tells me it's a binary and doesn't need to be configured.
I tried following the tutorial on mysql.com and gave up and then tried the instructions in the download (mysql-3.23.38-unknown-linux-gnu-sparc.tar.gz). Between the two it's running. Later I'm going to go back and do a clean download and ./configure just to see what I get.
I got the Tarball and compiled it. It seems to work fine other than when I logout and shutdown the server. It starts stopping all the processes, but when it gets to MySql it fails to stop it. The error reads something like, "etc/rc.d/rc6.d/??? killall etc/rc.d/init.d/??? killall not found [FAILED]
I have MySQL starting automatically when the server starts. Any ideas for a quick fix?