Skip to content

anil-arise1600/MySqlGUI

Repository files navigation

drawing MySQL GUI 1.1b

MySQL GUI is a UI based MySQL workbench. It is design as all SQL commands or queries to execute with user interactive mode.

Install Dependencies

	sudo apt update
	sudo apt install -y build-essential qt5-qmake qtbase5-dev qtbase5-dev-tools cmake git
	sudo apt install -y mysql-server libmysqlclient-dev
	sudo systemctl start mysql.service

Configure MySQL (root password)

	sudo mysql
	
	ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
	exit

Build with cmake

	git clone https://github.com/anil-arise1600/MySqlGUI.git
	cd MySqlGUI
	mkdir cBuild && cd cBuild
	cmake ..
	make

Build with qmake

	git clone https://github.com/anil-arise1600/MySqlGUI.git
	cd MySqlGUI
	mkdir qBuild && cd qBuild
	qmake ..
	make

MySQL Connection

alt text

Select Query on selection treeview item

alt text

Insert Values on selected treeview item with right click

alt text

alt text

References

  1. MySQL Install
  2. MySQL Queries
  3. Qt SQLDatabase programming