Mysql ERROR!

>>BLACKHOLE<< · 12-27-2006, 09:33 PM

hey whats up fellow members-
---------------------------

I'm having a problem that I could sure use help on!

Here it is.
__________________________________________________
GOAL:

I'm trying to setup a mysql database.

PROBLEM:

As root I issue the command # mysqladmin -u root password but I get the error message:

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!

As root this command # /etc/init.d/mysqld start gives this error:
chown: `mysql:mysql': invalid user Timeout error occured trying to start MySQL Daemon.
Starting MySQL:
FAILED

_____________________________________________________
SITUATION:

I installed mysql, php, apache already...
so I don't see why I should be getting this error message.
I've also checked some mysql tuts, but all seem to install the package by rpm command!

I just can't seem to envoke mine!!!
Can anyone help me with this issue??

Thanks ahead of time for all replys!
--------------------------------------------
________________
>>BLACKHOLE<<

+no knowledge or information can escape my dense gravitational pull<<

>>BLACKHOLE<<

2006-(-_+)

uselpa · 12-28-2006, 01:42 AM

You seem to be missing a user "mysql" and a group "mysql". Check /etc/group and /etc/passwd, and if they are indeed missing, create a group "mysql" and a user "mysql" who has as a primary group "mysql".

ALInux · 12-28-2006, 02:51 AM

I think error logs would be of most use to check the problem...but I think that the mysql server is not running.

try
ps aux | grep mysql

j-ray · 12-28-2006, 04:28 AM

the server is not running definetely as it did not start. you have to add the user and group and then start the server again.
cheers, j

>>BLACKHOLE<< · 12-28-2006, 10:42 PM

Hey guys-
--------

Thanks for the quick replys.

QUERY:

Does setting up Mysql user and group require installing mediawiki?
Mysql website doesn't explain things clearly...In my opinion!

This is getting kind of confusing!

Also I know I have to upload some files, can anyone recommend a good FTP for linux?
__________________________________________________________________
btw- ps aux | grep mysql brings this:

501 7928 0.0 0.2 2024 652 pts/1 S+ 00:17 0:00 grep mysql

__________________________________________________________________
>>BLACKHOLE<<

>>BLACKHOLE<<

2006-(-_+)

uselpa · 12-29-2006, 01:19 AM

Quote:

Originally Posted by >>BLACKHOLE<<

Does setting up Mysql user and group require installing mediawiki?

No, create them just like usual users and groups. You can assign a "system" uid and gid i.e. below 500 but that's cosmetic.

Quote:

Originally Posted by >>BLACKHOLE<<

btw- ps aux | grep mysql brings this:
501 7928 0.0 0.2 2024 652 pts/1 S+ 00:17 0:00 grep mysql

That means mysql is not running.

j-ray · 12-29-2006, 10:27 AM

take a look at
man useradd
or
man adduser
u only need 1 of these programs to create new users and groups...

crabboy · 12-29-2006, 11:45 AM

Moved: This thread is more suitable in Linux - Software and has been moved accordingly to help your thread/question get the exposure it deserves.

>>BLACKHOLE<< · 12-29-2006, 10:48 PM

hey guys-
--------

GOAL:

creating Mysql user and group!
________________________________________________________________

As root the command # rpm -qa | grep -i mysql brings this:

Mysql-common-4.1.12- 3mdk
Mysql-4.1.12-3mdk
perl-DBD-mysql-3.0002-1mdk
php-mysql-5.0.4- 1mdk
Mysql-client-4.1.12- 3mdk
libmysql14-4.1.12- 3mdk

QUERY:

All the Mysql tuts say to install mysql from tar then make user and group....

So should I uninstall my rpms and start over and install mysql from tar then do user and groups...or can I make user and group as is scince mysql is already installed on my system

Also when I issue the command # groupadd what should I name it?... and the same for useradd?

and after I make the group and user how do I issue a root password for it??
________________________________________________________________

This is my first attempt at something this big on a computer.. Hey I moving by instinct here.... Literally!!!
________________
>>BLACKHOLE<<

>>BLACKHOLE<<

2006-(-_+)

uselpa · 12-30-2006, 03:38 AM

Quote:

Originally Posted by >>BLACKHOLE<<

So should I uninstall my rpms and start over and install mysql from tar then do user and groups...or can I make user and group as is scince mysql is already installed on my system

Go with the mandrake packages, they have been tested to work with Mandrake. Don't install from source unless you have a reason to do so.

Quote:

Originally Posted by >>BLACKHOLE<<

Also when I issue the command # groupadd what should I name it?... and the same for useradd?

Look at the error message... both the user and the group should be called "mysql". On my Slackware box it looks like this:

Code:

pu@slackw:~$ cat /etc/passwd | grep mysql
mysql:x:27:27:MySQL:/var/lib/mysql:/bin/bash
pu@slackw:~$ cat /etc/group | grep mysql
mysql::27:

>>BLACKHOLE<< · 12-30-2006, 05:23 PM

ok-
___

The command cat /etc/my.cnf brings this:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Default to using old password format for compatibility with old and shorter password hash.
# Reference: http://dev.mysql.com/docmysql/en/Password_hashing.html
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err- log=/var/log/mysqld/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

-----------------------------------
The command groupadd brings:

group already exists
Same with useradd
------------------------------------------------
Still the /etc/init.d/mysql start command still times out-

Timeout error occured trying to start Mysql Daemon.FAILED

----------------------------------------------------------------
Does anybody have any other ideas that I could try????

________________
>>BLACKHOLE<<

>>BLACKHOLE<<

2006-(-_+)