Rabu, 12 November 2014

If you want to make easier to access your mysql (if use password to user root)

create .my.cnf in /root/
and put in it
[mysqladmin]
 user = root
 password = mysqlrootpassword
[mysql]
 user = root
 password = mysqlrootpassword
[mysqldump]
 user = root
 password = mysqlrootpassword
where offcourse mysqlrootpassword is your password for mysql's root password so when you execute mysql it uses this password
Remeber about safety of this file - put secure rights, so nobody on your server can read it!

Tidak ada komentar:

Posting Komentar