MySQL is most popular open source relational database. I have been using it myself for my PHP, Python and Ruby projects. Obviously, we need some client(s) to access MySQL database. In this post I am going to list down few clients.
Environment:
I am using XAMPP on Mac. You can install MySQL separately if you want to.
1. Desktop GUI client
Use SequelPro it is a nice tool and free.
Set it up and you are ready to go.
2. PHPMyAdmin
phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. It gets setup with XAMPP.
3. Terminal
Open up terminal and execute following commands -
Go to the directory with mysql binaries
cd /Applications/XAMPP/xamppfiles/bin;
Access mysql command line tool using
./mysql --user=root --password=
Environment:
I am using XAMPP on Mac. You can install MySQL separately if you want to.
1. Desktop GUI client
Use SequelPro it is a nice tool and free.
Set it up and you are ready to go.
2. PHPMyAdmin
phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. It gets setup with XAMPP.
3. Terminal
Open up terminal and execute following commands -
Go to the directory with mysql binaries
cd /Applications/XAMPP/xamppfiles/bin;
Access mysql command line tool using
./mysql --user=root --password=
Comments
Post a Comment