Installation of Mysql database

Posted by Adarshreddy Adelli

Add Comments

Tuesday, December 26, 2017

Mysql is a simple database which provides users to load and retrieve information. The information is stored in the form of tables and rows..

⏩Installing MySQL Database on Windows:

▶ Install mysql database server only and select server machine as server type.

▶Now run it as service.

▶Then lauch its command line client using the following command.

mysql -u root -p

🔊The -p option is required only if a root password is defined for MySQL. Enter the password when prompted.

⏩MySQL on Ubuntu and CentOS

▶Ubuntu

sudo apt-get install mysql-server

▶Centos

sudo yum install mysql-server

/etc/init.d/mysqld start.

➡📁SETTING UP SQL DATABASE USING PYTHON

Adarshreddy Adelli

As an Engineering Lead with deep expertise in Artificial Intelligence, Cybersecurity, and Systems Architecture, I guide teams in building innovative, secure, and scalable solutions.I am passionate about tackling challenging technical problems, fostering engineering excellence, and delivering solutions that balance innovation, security, and performance. I actively share knowledge through blogging and community engagement, contributing to the advancement of AI and cybersecurity practices.