624
edits
Changes
From SME Server
Jump to navigationJump to searchclarified login domain & admin password commands & text
==Utilisation==
==Utilisation==
You can access phpmyadmin interface by opening your web browser at the address:
You can access phpmyadmin interface by opening your web browser at the address:
https://[IP ou NOM]/myadmin
https://[IP or DOMAIN]/myadmin
A login and a password is needed to connect.
A login and a password is needed to connect.
By default, installation process create a user "admin" with "admin" as password.
By default, the installation process creates a user "admin" with "admin" as password.
'''Of course, the first thing you have to do, is to change it'''
'''Of course, the first thing you have to do, is change the admin password.'''
Use the following commands (replace newpassword with your actual desired admin password).
mysql --execute="grant all privileges on *.* to admin@localhost identified by 'admin' WITH GRANT OPTION"
You can also use the same commands to reset the admin password to admin, if you have any problems connecting (ie replace newpassword with the word admin). You must be logged in as the root user.
mysql --execute="grant all privileges on *.* to admin@localhost identified by 'newpassword' WITH GRANT OPTION"
mysql --execute="flush privileges"
mysql --execute="flush privileges"
