Home » MySQL
How to Access MySQL via SSH Tunnel
Intipadi.com - This is a particularly useful method for gaining access to your remote MySQL databases, such as those held on a web hosting account where the MySQL port may not be open. You can use this method to gain access to other services too (SMTP, IMAP, FTP), but in this post I’ll explain how I use it in combination with MySQL Query Browser to administrate my DBs with a GUI. You need to have...
Navicat SSH Error, Lost Connection on Reading Initial Communication Packet
intipadi.com - Kasus ini terjadi mungkin pada anda yang baru saja selesai menginstal LAMP server. Anda masih lupa untuk melakukan allow dan deny host pada beberapa hal. Contoh kasusnya adalah koneksi ke mysqld dengan Navicat muncul error “Lost connection on reading communication packet”.
Solusinya adalah meng-allow mysqld di file hosts linux server anda. Masuk ke terminal/konsole:
vim...
How to create a MySQL database for virtual accounts?
Intipadi – Do you know you can use MySQL to make a own database for your virtual accounts? this is the steps:
There are a lot of uses for MySQL. Here are the steps to creating a user database that could be used with a FTP server, mail server or web server.
Login and create the database.
mysql -p -u root
CREATE DATABASE virtual;
Whatever you choose to call the database does not matter except...