4259 links
  • Arnaud's links
  • Home
  • RSS Feed
  • Tag cloud
  • Login
search: tag:auth tag:mysql — newest first
  • MySQL :: MySQL 5.7 Reference Manual :: 5.6.6 mysql_config_editor — MySQL Configuration Utility

    Exactement ce que je cherchais

    You can use the mysql_config_editor utility to store authentication credentials in an encrypted login path file named .mylogin.cnf.

    To create a new set of credentials run:

    mysql_config_editor set --host=db.host.org --user=dbuser --password

    and enter your password when prompted.

    This will store your authentication credentials in the default client login path.

    You can store multiple authentication credentials by specifying a different --login-path option:

    mysql_config_editor set --login-path=db2 --host=db2.host.org --user=dbuser --password

    By default, the mysql client reads the [client] and [mysql] groups from other option files, so it reads them from the login path file as well. With a --login-path option, client programs additionally read the named login path from the login path file. The option groups read from other option files remain the same. Consider this command:

    mysql --login-path=db2

    The mysql client reads [client] and [mysql] from other option files, and [client], [mysql], and [mypath] from the login path file.

    To print out all the information stored in the configuration file run:

    mysql_config_editor print --all=true

    More information about the utility can be found at "mysql_config_editor — MySQL Configuration Utility".

    May 3, 2017 - permalink - https://dev.mysql.com/doc/refman/5.7/en/mysql-config-editor.html
    auth mysql
  • Connexion sécurisé base de donnée sans mot de passe depuis compte linux

    via sebsauvage

    October 1, 2014 - permalink - http://www.mon-code.net/article/72/utiliser-le-compte-linux-pour-se-connecter-de-facon-securise-a-mariadb-et-mysql-sans-mot-de-passe
    auth mariadb mysql