[F9,mysql] mysql server inacessible

[lolveley]

hello,

I have inst-alled mysql with the command

yum install mysql*

, all was right, but I can't access to it with the mysql administrator (I don't know what to enter near: host, username, password (under Windows, after the installation it is possible to configure mysql).
moreover, mysqlshow don't run well:

[lolveley@localhost ~]$ mysqlshow mysqlshow: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 

[lolveley@localhost ~]$

can ya help me to configure it?

thanks,

lolveley.

[jim]

first open a shell

su -  

service mysqld start

if u get a error then u dont have the server installed or the service is dead

first try

service mysqld stop service mysqld start

if comes back not recognized then try the following

yum install mysql-server

make sure the service is running with

service --status-all | grep mysqld

[jim]

Also dont forget to set the root password afterwards since the defaullt password is not there

from the shell mysql -u root

then enter the following make sure you change the MyNewPass to something u want
and also copy it to a text editor first make the change then copy from the text editor to the shell


UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

[lolveley]

here are some news.

the socket

/var/lib/mysql/mysql.sock

does not exist. but why, I do not know.

I tried some tips:

- for "service mysqld start":

[lolveley@localhost ~]$ service mysqld start
bash: service: command not found
[lolveley@localhost ~]$ su
Mot de passe :
[root@localhost lolveley]# ./service mysqld start
bash: ./service: Aucun fichier ou dossier de ce type
[root@localhost lolveley]# whereis service
service: /sbin/service /usr/share/man/man8/service.8.gz
[root@localhost lolveley]# cd /sbin
[root@localhost sbin]# service mysqld start
bash: service: command not found
[root@localhost sbin]# sh service mysqld start

^C
[root@localhost sbin]# ls ser*
service
[root@localhost sbin]#

I can't run it... and don't know why a new time.

- for "yum install mysql-server":

[root@localhost sbin]# yum install mysql-server
Modules complémentaires chargés*: refresh-packagekit
Configuration du processus d'installation
Traitement des options d'installation des paquetages
Le paquetage mysql-server-5.0.51a-1.fc9.i386 est déjà installé dans sa dernière version
Rien à faire

all is right, the package is already installed.

- for "service --status-all | grep mysqld ":

[lolveley@localhost ~]$ service --status-all | grep mysqld
bash: service: command not found
[lolveley@localhost ~]$

the same error as above.


lolveley.

[markkuk]

Use "su -", not "su" to switch to root user. The " -" part that you omitted is essential.

[lolveley]

ok.
I tried to use "su -" and here is the result:

su -
service mysqld start

result:
the window:
AVC access denied.
with the error:

Résumé:

SELinux is preventing mono (unconfined_mono_t) "unix_read unix_write" to <Inconnu>
(unlabeled_t).

Description détaillée:

SELinux denied access requested by mono. It is not expected that this access is
required by mono and this access may signal an intrusion attempt. It is also
possible that the specific version or configuration of the application is
causing it to require additional access.

Autoriser l'accès:

Vous pouvez créer un module de politique locale pour autoriser cet accès -
lisez la FAQ (http://fedora.redhat.com/docs/selinu...fc5/#id2961385) Vous
pouvez également désactiver la protection fournie par SELinux. Désactiver
SELinux n'est pas recommandé. Merci de remplir un rapport de bug
(http://bugzilla.redhat.com/bugzilla/enter_bug.cgi) sur ce paquetage.

Informations complémentaires:

Contexte source unconfined_u:unconfined_r:unconfined_mono_t:s0-s0:
c0.c1023
Contexte cible system_u:object_r:unlabeled_t:s0
Objets du contexte None [ sem ]
source mono
Chemin de la source /usr/bin/mono
Port <Inconnu>
Hôte localhost.localdomain
Paquetages RPM source mono-core-1.9.1-2.fc9
Paquetages RPM cible
Politique RPM selinux-policy-3.3.1-79.fc9
Selinux activé True
Type de politique targeted
MLS activé True
Mode strict Enforcing
Nom du plugin catchall
Nom de l'hôte localhost.localdomain
Plateforme Linux localhost.localdomain 2.6.25-14.fc9.i686 #1
SMP Thu May 1 06:28:41 EDT 2008 i686 i686
Compteur d'alertes 1
Première alerte lun 04 aoû 2008 13:34:30 CEST
Dernière alerte lun 04 aoû 2008 13:34:30 CEST
ID local 348bd8b7-2e43-4899-8418-a8858344dc7b
Numéros des lignes

Messages d'audit bruts

host=localhost.localdomain type=AVC msg=audit(1217849670.241:77): avc: denied { unix_read unix_write } for pid=24932 comm="mono" key=1291862090 scontext=unconfined_u:unconfined_r:unconfined_mono _t:s0-s0:c0.c1023 tcontext=system_u:object_r:unlabeled_t:s0 tclass=sem

host=localhost.localdomain type=SYSCALL msg=audit(1217849670.241:77): arch=40000003 syscall=117 per=400000 success=no exit=-13 a0=2 a1=4d00404a a2=8 a3=180 items=0 ppid=1 pid=24932 auid=500 uid=500 gid=500 euid=500 suid=500 fsuid=500 egid=500 sgid=500 fsgid=500 tty=(none) ses=1 comm="mono" exe="/usr/bin/mono" subj=unconfined_u:unconfined_r:unconfined_mono_t:s 0-s0:c0.c1023 key=(null)

moreover, there is the command line result:

Timeout error occurred trying to start MySQL Daemon.
Démarrage de MySQL*: [ÉCHOUÉ]

this means that the launch of Mysql was a failure.


regards,

lolveley.

[lolveley]

why "su -" is better than "su"?
could be there a possible origin of the troubles?

lolveley.

[markkuk]

The SELinux error you quoted is completely unrelated, or your system clock is off by several days. Look for an error with date/time that matches your attempt to start the mysql server.