MySQL installed when Redhat installed

dixondwayne

I'm getting errors. Has anyone went through doing this? I'm a beginner at Linux, Unix, and mySQL, but not a beginner on computers.

Is mySQL ready to go after I install Linux? I've tried to start it via safe_mysqld and it seems to work but when I execute mysqladmin ping or version it says 'connect to server at localhost failed' and then says some stuff about the sock file.

Another question... I'm guessing Linux used an RPM during its own install to install mySQL. I've looked around and I can't tell when I'm reading about RPM related installs vs. other installs. How different are the installs? I can't even determine if my install is a binary distro or a source distro? I doubt Redhat unpacked mySQL, compiled and installed not using the RPM thingy.

Any advice would be nice. I follow direction well and I read well if I could find something specific to the Redhat/mySQL/install/RPM issue. Even the Redhat and mySQL docs don't cover this in great detail.

Thanks,
Dwayne

dixondwayne

I still need help.

tha_mink

Check your logs and see where mysqld is looking for the mysql.sock file. Then search for it. Once you find where your mysql.sock file is...make a link to it wherever mysqld is looking to find it. That will usually do the trick.

ratso

Go to the Red Hat Package manager and then search for MySQL, it will show any rpms installed and will also give you the version of MySQL

also you could go to the shell prompt and type

whereis mysql

then you wil be told where abouts it it installed

usually /usr/bin/mysql /usr/lib/mysql

tha_mink

Yes but he needs the header files not the binary. Just look for mysql.h and point php there.

ratso

ooops!

guess I should read more thoroughly

still Im only a beginner myself

Ratso

dixondwayne

My still stuck. I've tried a lot of things.

Now, I'm get this error in mysqld.log.

mysqld started
bdb: /var/lib/mysql/mysql/log.0000000001: Permission denied
dbd: PANIC: Permission denied
Can't init databases
mysqld ended

Everything I read says to do something with "mysql" or "mysqladmin" and neither of these work on my system.

How do I uninstall this version to install a version by compiling it? I'd like to get away from what the RPM did and just start over. Does anyone think this is a good idea?

If I install "ANY" version in "ANY" of the many ways... should I install under ROOT or a regular account?

Thanks,
Dwayne

dixondwayne

One more thing... please help... I want so so so bad to leave M$ behind and in the dust.

tha_mink

Well...look at the error...Permissions denied. What do YOU think the problem is? I bet it's bad permissions on your /var/lib/mysql dir or your /var/lib/mysql/mysql/ dir

if not that than the permissions on the files in /var/lib/mysql/mysql/ dir. check em. make em 777 and see what happens...if it works make em 755. If that breaks it again open em back up to 777.

Error messages are there to tell you what is wrong. In your case...your directory permissions need adjustment.

tha_mink

dixondwayne

I'm new at Unix.

I did see that some people were using "chown" on the directories, but I didn't want to do this because it might get me in trouble in other ways.

I'm logged in as root, I'm doing all this as root... is that okay?

If I'm doing all this as root - I thought root was super powerful - how can I get a permissions error using root?

mysql is a user - is this user being used in some way to run mysqld?

As root, I'll try 777 and see what happens.... I do this using chmod... read a bit about this command last night. This command seems more like it is provided to SHARE than to totally change the owner so it seems less risky.

ratso

I struggled a lot with mysql when i first started using Redhat, the way round I found it was to uninstall the current msyql installed (with Red Hat package manager), then re-installl the mysql rpms off of the redhat installation disk using the package manager. After this mysql ran okay.

I use MySQL cc and phpMyAdmin for my DB admin, cc being a tiny download and phpMyAdmin being easy to get going.

I just have to console myself with the fact that I compiled Apache and PHP from tars, but MySQL beat me and I had to installed via the Red Hat Package Manager. 🙁
Try this road, as it led me to be able to develop my databases on a linux system instead of Windows.

I know the frustration when beginning and trying to get everything just to work.

Hope you get it working,

Ratso

dixondwayne

Okay, I uninstalled and then installed 4.0 and all is working.

I tried giving permissions and it worked! -- sort of -- I just started to get a different error. 🙁

I have another question. I'm moving to PHP. Is all the software on Linux installed independent of another? I have to get PHP, Apache and MySQL working together. Is there any order to installing and etc.? I've read a lot and it seems a lot has to be done to all sorts of scripts.... is it easier than it reads?

I would have been nice to get my first version of MySQL working, however I was sure that if I did, I wouldn't have know what 'exactly' I did to get it working. I was trying so much. I think starting over was best.

Thanks! to everyone that tried to help me.

Thanks to the open source community for providing software which will enable me to tell M$ to go to HELL.

😃

ratso

I have found since I have been using linux that as long as you have glibc (c libraries) as I understand it, you can compile stuff like apache, php without problems.

The best way I found to install apache was to download the latest tar.gz file from www.apache.org and then compile it, It is pretty straight forward as long as you read the README carefully

After installing that I complied PHP , again after downloading the tar.gz file from www.mysql.com which was also pretty straightforward , just make sure you read the README carefully

Overall the majority of tar.gz stuff I have installed is a simple as typing these commands in the unzipped directory of the thing I want to compile:

./configure
make
make install

Although, I must admit I am struggling with xanim at the moment, but Im still only a beginner

good luck, and dont give up!

Ratso

tha_mink

Here is an decent tutorial for you.

http://www.blazonry.com/scripting/install_apache.php