ispCP - Board - Support
MySql - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega International Area (/forum-22.html)
+--- Forum: French Corner (/forum-25.html)
+--- Thread: MySql (/thread-9170.html)



MySql - Sleement - 01-12-2010 09:49 AM

Bonjour,
suite a mon installation j'ai encore beaucoup de problème.

je bloque ici.

Code:
Welcome to ispCP '1.0.3 OMEGA' Setup Dialog.

        This program will set up ispCP OMEGA system on your server.

        Next you are asked to enter a "fully qualified hostname" (FQHN).
        For more infos read http://en.wikipedia.org/wiki/FQDN.


        Please enter a fully qualified hostname. [serveur1.11111111.com]: www.111111111.com

        Please enter system network address. [11.11.11.11]:

        Please enter the domain name where ispCP OMEGA will run on [admin.serveur1.111111.com]: panel.1111111111.com

        Please enter SQL server host. [localhost]:

        Please enter system SQL database. [ispcp]:

        Please enter system SQL user. [root]:

        Please enter system SQL password. [none]:
        Please repeat system SQL password:

        Please enter ispCP ftp SQL user. [vftp]:

        Please enter ispCP ftp SQL user password. [auto generate]:
        ispCP ftp SQL user password set to: 1111111111

        Please enter ispCP phpMyAdmin Control user. [pma]:

        Please enter ispCP phpMyAdmin Control user password. [auto generate]:
        phpMyAdmin Control user password set to: 1111111111

        Please enter administrator login name. [admin]:

        Please enter administrator password:
        Please repeat administrator password:

        Please enter administrator e-mail address: 111111111111

        IP of Secondary DNS. (optional) []:

        Use MySQL Prefix.
        Possible values: [i]nfront, [b]ehind, [n]one. [none]:

        FastCGI Version: [f]cgid or fast[c]gi. [fcgid]:

        Activate AWStats. [no]:

        Starting Installation...
ERROR: Unable to connect SQL server !

Aussi,
quand je redemarre mysql j'ai bizzarment cette petite erreur. sa fait sa depuis que j'ai perdu le mots de pass mysql.


Code:
# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
#



RE: MySql - Nuxwin - 01-12-2010 09:58 AM

Bonjour ;

Le script d'installation ne doit pas être exécuté plusieurs fois. Il faut faire un reset avant (voir la documentation). Concernant votre serveur Mysql, il faut corriger le problème avant d'installer ispCP. Vous devriez assigner un nouveau mot de passe à l'utilisateur root SQL.

Enfin, en ce qui concerne le message obtenu lors du re-démarrage du serveur Mysql, il ne s'agit pas d'une erreur.

Cordialement ;


RE: MySql - Sleement - 01-12-2010 10:02 AM

(01-12-2010 09:58 AM)nuxwin Wrote:  Bonjour ;

Le script d'installation ne doit pas être exécuté plusieurs fois. Il faut faire un reset avant (voir la documentation).

Petit problème,
et comment on fait un reset je suis quand même pas bon sur debian...


merci




Et en plus je suis pas capable de me connecté.
Code:
# mysql_secure_installation




NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Enter current password for root (enter for none):
Aborting!




Ya tu un moyen d'enlever mysql au complet ?





Et la poche comme je suis j'ai tout fourré l'affaire.
Code:
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!



RE: MySql - Nuxwin - 01-12-2010 12:20 PM

Problème réglé. L'utilisateur avait supprimé l'utilisateur root SQL.