Fedora Linux Support Community & Resources Center
  #1  
Old 7th August 2008, 11:39 AM
lolveley Offline
Registered User
 
Join Date: Aug 2008
Location: Metz, FRANCE
Age: 40
Posts: 54
[F9,mysql] mysql server inacessible

hello,

I have inst-alled mysql with the command
Quote:
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:
Code:
[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.
Reply With Quote
  #2  
Old 7th August 2008, 11:54 AM
jim Offline
Retired Community Manager & Avid Drinker Of Suds
 
Join Date: Feb 2005
Location: Rochester NY
Age: 40
Posts: 4,175
first open a shell

Code:
su -  

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

first try
Code:
service mysqld stop service mysqld start
if comes back not recognized then try the following
Code:
yum install mysql-server
make sure the service is running with
Code:
service --status-all | grep mysqld
__________________
Registered Linux User: #376813
Western NY
My linux site
Smolt Profile

please remember to say if you problem was solved

Did you get your id10t award today?

Last edited by jim; 7th August 2008 at 11:58 AM.
Reply With Quote
  #3  
Old 7th August 2008, 12:11 PM
jim Offline
Retired Community Manager & Avid Drinker Of Suds
 
Join Date: Feb 2005
Location: Rochester NY
Age: 40
Posts: 4,175
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;
__________________
Registered Linux User: #376813
Western NY
My linux site
Smolt Profile

please remember to say if you problem was solved

Did you get your id10t award today?
Reply With Quote
  #4  
Old 7th August 2008, 12:38 PM
lolveley Offline
Registered User
 
Join Date: Aug 2008
Location: Metz, FRANCE
Age: 40
Posts: 54
here are some news.

the socket
Quote:
/var/lib/mysql/mysql.sock
does not exist. but why, I do not know.

I tried some tips:

- for "service mysqld start":
Quote:
[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":
Quote:
[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 ":
Quote:
[lolveley@localhost ~]$ service --status-all | grep mysqld
bash: service: command not found
[lolveley@localhost ~]$
the same error as above.


lolveley.
Reply With Quote
  #5  
Old 7th August 2008, 02:36 PM
markkuk Offline
Registered User
 
Join Date: Apr 2005
Location: Finland
Posts: 5,075
Use "su -", not "su" to switch to root user. The " -" part that you omitted is essential.
Reply With Quote
  #6  
Old 7th August 2008, 03:13 PM
lolveley Offline
Registered User
 
Join Date: Aug 2008
Location: Metz, FRANCE
Age: 40
Posts: 54
ok.
I tried to use "su -" and here is the result:
Quote:
su -
service mysqld start
result:
the window:
AVC access denied.
with the error:
Quote:
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:
Quote:
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.
Reply With Quote
  #7  
Old 7th August 2008, 03:15 PM
lolveley Offline
Registered User
 
Join Date: Aug 2008
Location: Metz, FRANCE
Age: 40
Posts: 54
why "su -" is better than "su"?
could be there a possible origin of the troubles?

lolveley.
Reply With Quote
  #8  
Old 7th August 2008, 04:29 PM
markkuk Offline
Registered User
 
Join Date: Apr 2005
Location: Finland
Posts: 5,075
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.
Reply With Quote
Reply

Tags
inacessible, mysql, server

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to install mysql MySQL-server-4.0.26-0 FC2 or Upgrade 3.23.58-16.FC2.1 from to 4 niloshima EOL (End Of Life) Versions 1 28th October 2005 06:25 PM
Question about yum install apache2, php, mysql, php-mysql... cpthk Servers & Networking 6 21st September 2005 08:25 AM
MySQL: Can't open privilege tables: Incorrect information in file: './mysql/host.frm' benjamin.choi Servers & Networking 1 25th June 2005 04:19 PM
Install mail server from Postfix/CyrusSASL2/PAM-MySQL/MySQL/Dovecot/Amavisd/Clamav chengcsw Guides & Solutions (No Questions) 7 26th April 2005 08:38 PM


Current GMT-time: 09:28 (Sunday, 26-10-2014)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat
Bahau Travel Photos on Instagram - Al Hudaydah Travel Photos - Greenwood Photos on Instagram