Home
Join

12 Replies

  • Le compte dispose-t-il des autorisations appropriées pour effectuer les actions qui lui sont demandées?

    Was this post helpful? thumb_up thumb_down
  • Oui il dispose de tous les autorisations mais svp donne moi la commande et je vais retester merci pour votre retour

    Was this post helpful? thumb_up thumb_down
  • L'impression que j'ai est que le compte en question n'a pas d'autorisation sur l'autre serveur pour l'accès à distance. Je vérifierais que le compte est autorisé et dispose des autorisations appropriées pour accéder à distance au serveur SQL.

    Was this post helpful? thumb_up thumb_down
  • Comment puis je vérifie ça svp ?

    Was this post helpful? thumb_up thumb_down
  • Comment puis je vérifie ça svp ?

    Was this post helpful? thumb_up thumb_down
  • Comment je peux vérifier les autorisations au niveau du mysql
    On 3 serveurs separer
    1 pour management
    2 pour mysql
    C est un cluster

    Was this post helpful? thumb_up thumb_down
  • Make sure you are not using a root account for that purpose. External connections for root are disabled by default in MySQL. Try using/creating a different account or modify root account permissions:

    SQL
    #Remote access for any IP
    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';
    
    #Remote access for Specific Ip
    GRANT ALL PRIVILEGES ON *.* TO 'root'@'your_desire_ip' IDENTIFIED BY 'password';
    

    Since you are running PHPMyAdmin on an external host, it is also required to check and configure your firewall to allow incoming connections on the 3306 port.

    Depending on the installation, you may also need to check your MySQL configuration for server bindings since it may be equal to 127.0.0.1 by default preventing your MySQL server from listening for external requests at all.

    All those changes have to be done on both MySQL hosts participating in the cluster.

    Honestly, I wouldn't say I like how most SQL clusters are built and performing. That is why I prefer running them inside a single highly-available virtual machine on top of mirrored virtual storage like virtual SAN https://www.starwindsoftware.com/starwind-virtual-sanOpens a new window. That makes management, maintenance, and backup/restore much more straightforward.

    Pepper graySpice (3) flagReport
    2 found this helpful thumb_up thumb_down
  • Bonjour merci pour votre retour,
    Les commandes d'autorisation dont vous m'avez envoyé sont déjà testé, mais toujours pas d'accès.
    Pour le pare-feu est désactivé carrément.
    Comment je peux vérifier le fichier de configuration du MySql et quelle sont les recommandations à appliquer côté MySql et PhpMyadmin?
    Merci

    Pepper graySpice (1) flagReport
    Was this post helpful? thumb_up thumb_down
  • The configuration file should be located at /etc/mysql/my.cnf. Check for the bind-address = 127.0.0.1 line and comment/remove it to allow your MySQL server to listen on external IP addresses as well.

    Have you tried running PHPMyAdmin on the same machine where the MySQL server is running? Such configuration is a bit more simple and may work for you, at least temporarily, while you are fixing the dedicated management machine.

    Pepper graySpice (1) flagReport
    1 found this helpful thumb_up thumb_down
  • Merci pour votre réponse.
    Comment puis je executer mon phpmyadmin au niveau de la machine virtuelle centos (ligne de commande)

    Was this post helpful? thumb_up thumb_down
  • spicehead-a40zg wrote:

    Comment puis je executer mon phpmyadmin au niveau de la machine virtuelle centos (ligne de commande)

    The installation is pretty easy, actually, and not very different from any other Linux distributive https://www.hostinger.com/tutorials/how-to-install-phpmyadmin-on-centos-7/Opens a new window.
    Pepper graySpice (3) flagReport
    2 found this helpful thumb_up thumb_down
  • Thanks for mentioning StarWind.

    Hey,

    StarWind VSAN can be used as fault-tolerant storage synchronized between sites/nodes in real-time. This will allow you to create a cluster and deploy a highly available virtual machine on top without the need to use complicated built-in clustering features of MySQL. As opposed to database replication, you will get an active-active virtual machine, having the same data on both physical nodes at the same time.

    You can find more details about the concept here: https://www.starwindsoftware.com/fault-tolerance-and-high-availability-pageOpens a new window.

    Our engineers will gladly help you build a PoC and configure everything, including PHPMyAdmin, so feel free to DM me if you have any questions or need assistance.

    P.S. Our best tech guys talk French just perfectly, so no issues here ;-)

    Pepper graySpice (3) flagReport
    2 found this helpful thumb_up thumb_down

Read these next...