MariaDB / Mysql

Password management

By default, CC-IN2P3 interactive servers have one client for each DBMS.

Client mysql pour MySQL ou MariaDB

% mysql -h <service>.in2p3.fr -P <port> -u <username> -p <database>

At you first connexion, it is strongly recommended to change the password. The following command can be placed in the different clients:

MariaDB [dbname]> set password = password('<new password>');
Query OK, 0 rows affected (0.00 sec)

PhpMyAdmin

The CC-IN2P3 provides access restricted PhpMyAdmin instances to access your databases.

To obtain access to these instances, you must:

  • Be the owner of a database on the relevant MariaDB server.

  • Have a CC-IN2P3 account.

  • Have the PhpMyAdmin service administrators assign the correct role to your CC-IN2P3 account.

Please contact user support to request this access.

Availabe PhpMyAdmin instances

https://phpmyadmin.cc.in2p3.fr

Instance providing access to the ccmysql.in2p3.fr server.

https://pma-expe.cc.in2p3.fr

Instance providing access to the ccmyga02.in2p3.fr server.