GRANT ALL ON dbname.* TO 'dbuser'@'localhost'
- dbname: your database name.
- dbuser: ex. root, vmusr
and view in /mysqlaccess.conf
# ----------------#
# Global settings #
# --------------- #
#$Param{'host'} = '';
$Param{'user'} = 'nobody';
$Param{'db'} = 'test';
$Param{'password'} = 'foobar';
$Param{'debug'} = 0;
# --------------------------#
# Settings for Command-line #
# ------------------------- #
if ($CMD) {
$Param{'superuser'} = 'root';
$Param{'rhost'} = 'localhost';
$Param{'spassword'} = '';
$Param{'brief'} = 1;
}
or set in mysql-shell:
$ mysql -u root -p yourpass
after login:
shell> mysql --host=remote.example.com --port=13306