Mysql rpm installation

[Dexymous]

Im trying to install mysql on a server running centOS 5 but when i try to install the package i get the following error:

# rpm -i MySQL-server-5.0.45-0.glibc23.i386.rpm
FATAL ERROR /root/mysql/bin/mysqld not found!
/etc/init.d/mysql: line 269: cd: /root/mysql: No such file or directory
Starting MySQLCouldn't find MySQL manager or server[FAILED]

can someone please help me solve this problem?

[Dexymous]

i managed to install it by creating a new user and logging into that user as opposed to being logged in as the root user. however when i try to connect to mysql its says
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
i checked and it doesnt exist. how can i fix this?

[Nabaachy]

Hi,
I also had that problem once, and i searched every where to over come it. but i couldnt find any solution. the only way it worked for me was by compiling mysql from source.

Nabaachy

[Dexymous]

Thank you Nabaachy.
Sorry but since i am very new to linux can you please give me instructions on how to do this or please provide me with a link on how to compile a source. Thx

[Dexymous]

I actually managed to get a version of mysql on the server but it fails when i run:
scripts/mysql_install_db --user=mysql

i ran the file
/usr/local/mysql/configure and it says:


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 MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time ...
...You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &
...
[root@localhost mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/localhost.localdomain.pid
091123 20:38:41 mysqld ended

but when i try and run the server using cd . ; ./bin/mysqld_safe & it has a lot of errors about /root/mysql/ which is a folder that doesnt exist... why is it not starting from /usr/local/mysql/?

heres the error it outputs:

[root@localhost mysql]# cd . ; ./bin/mysqld_safe &
[1] 23833
[root@localhost mysql]# touch: cannot touch `/root/mysql/data/localhost.localdomain.err': No such file or directory
chown: cannot access `/root/mysql/data/localhost.localdomain.err': No such file or directory
Starting mysqld daemon with databases from /root/mysql/data
./bin/mysqld_safe: line 380: /root/mysql/data/localhost.localdomain.err: No such file or directory
./bin/mysqld_safe: line 388: /root/mysql/data/localhost.localdomain.err: No such file or directory
STOPPING server from pid file /root/mysql/data/localhost.localdomain.pid
tee: /root/mysql/data/localhost.localdomain.err: No such file or directory
091123 20:44:24 mysqld ended
tee: /root/mysql/data/localhost.localdomain.err: No such file or directory


[1]+ Exit 1 ./bin/mysqld_safe

[Nabaachy]

Hi,
I followed this tutorial to set up LAMP, but as im a noob, i coundt get php working, but mysql works fine. im using fedora, so cent Os wont be that different from it. do you know where to put php files in order to open it with apache? im putting them in html folder, in /www. maybe html is the wrong folder to put them.

hope this link helps you.

link LAMP (Linux, Apache, MySQL, PHP) HOWTO: Installing MySQL and Apache with PHP support on Linux

Nabaachy