Home » Archive by category "MySQL Questions"

How to search a column name within all tables of a database

Search a column name within all tables of a database For example, You have a database named project and you have more than one table where project_id column is present, then you can find similar column name with all tables using following SQL query. select table_name,column_name from information_schema.columns where...
Continue reading »

How to Enable MySQL Remote Access on Ubuntu Server

Enable MySQL Remote Access on Ubuntu Server By default, MySQL only allows connections from the same machine (i.e. only from localhost). So if you only plan to access MySQL from an application that runs on the same machine, you are already good to go. However, I find it...
Continue reading »

How to Remove MySQL Server in ubuntu 12.04?

How to completely remove Mysql installation in Ubuntu 12.04 Using the Apt command. sudo apt-get –purge remove mysql-server sudo apt-get –purge remove mysql-client sudo apt-get –purge remove mysql-common sudo apt-get autoremove sudo apt-get autoclean Find all the files with “mysql” on / and delete them: sudo find /...
Continue reading »