MySQL is an open-source relational database management system (RDBMS) that is widely used for managing and manipulating structured data. It is one of the most popular database systems in the world, known for its reliability, performance, and ease of use.
Here are some key features of MySQL:
Relational Database: MySQL is a relational database, which means it organizes data into tables with rows and columns, and establishes relationships between them.
SQL Support: MySQL uses Structured Query Language (SQL) as its primary language for querying and managing data. SQL is a standard language for interacting with relational databases.
Cross-Platform: MySQL is available on multiple platforms, including Linux, Windows, macOS, and various Unix-like operating systems, making it versatile and widely compatible.
Scalability: MySQL is known for its scalability, allowing it to handle large volumes of data and high traffic loads efficiently. It supports both vertical and horizontal scaling.
Performance: MySQL is optimized for performance, with features such as indexing, caching, and query optimization to ensure fast and responsive database operations.
Security: MySQL provides robust security features to protect data, including user authentication, access control, encryption, and auditing capabilities.
Community and Support: MySQL has a large and active community of developers and users who contribute to its development, provide support, and share knowledge through forums, documentation, and other resources.
MySQL is commonly used in web development, powering many popular websites and web applications. It is often used in conjunction with programming languages like PHP, Python, and Java to build dynamic and data-driven web applications. Additionally, MySQL is used in various other industries and applications, including e-commerce, finance, telecommunications, and more.
mysql installation command for centoes 7 community version-7
wget https://dev.mysql.com/get/Downloads/MySQL-8.3/mysql-8.3.0-1.el7.x86_64.rpm-bundle.tar
wget https://dev.mysql.com/get/mysql80-community-release-el7-11.noarch.rpm
yum localinstall mysql80-community-release-el7-11.noarch.rpm
cd /etc/yum.repos.d
vi mysql-community.repo
change the repolist 8 to 7 .
1 means 7
0 means 8
yum repolist
yum install mysql-community-server
systemctl restart mysqld
systemctl status mysqld
mysql -V
systemctl enabled mysqld
#password mysql generate
grep "A temporary password" /var/log/mysqld.log | tail -1
#set new password
mysql_secure_installation
mysql -u root -p