What is Mysql: Definition and 29 Discussions

MySQL () is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language. A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.
MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun Microsystems (now Oracle Corporation). In 2010, when Oracle acquired Sun, Widenius forked the open-source MySQL project to create MariaDB.MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often, MySQL is used with other programs to implement applications that need relational database capability. MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python. MySQL is used by many database-driven web applications, including Drupal, Joomla, phpBB, and WordPress. MySQL is also used by many popular websites, including Facebook, Flickr, MediaWiki, Twitter, and YouTube.

View More On Wikipedia.org
  1. A

    Is MySQL or PostgreSQL more ACID compliant for database projects?

    Hello All, I am working on a database project and I am good at SQL commands. I want to know which one supports ACID compliant between MySQL and PostgreSQL. I have asked this question on Quora and according to this post, MySQL is not completely ACID compliant. It supports ACID only when used in...
  2. F

    What does it mean that MySQL is a server application?

    I would like to practice SQL and install MySQL, one of the most popular open source DMBS. MySQL workbench can also to be installed and used as a visual GUI to interact with MySQL which in turns interacts with the database. My question: is MySQL a server application? If so, what does it mean? I...
  3. Wrichik Basu

    Trouble installing MySQL on Ubuntu 20.04 — asks for root password

    I wanted to install MySQL on my laptop running Ubuntu 20.04, and was following this website for instructions. I executed the following commands: ~$ sudo apt update ~$ sudo apt install mysql-server ~$ sudo mysql_secure_installation After installation, I found that I could log into root user...
  4. Wrichik Basu

    Searching through many tables in MySQL

    I have a database of bus routes in MySQL. Each table has three columns: location1, location2 and fare for going from location1 to location2. Consider one table of this database, route_a which goes via region1 → region2→ region3 → region4: and another table, route_b which goes via region5 →...
  5. Wrichik Basu

    Mysqld command does not start the MySQL Server

    I just installed MySQL Server 8.0. The server is configured to run automatically at startup. However, when I wake up my laptop from hibernation or sleep, sometimes the server stops. I read on the net that I should execute mysqld from command line to start the server. I have set the folder of...
  6. W

    What is the T-SQL version for MySQL?

    Hi, Just curious as to what, if any procedural language MySQL extends to, in the way SQL Server's SQL extends to T-SQL, Oracle SQL extends to PL/SQL? Is it PHP? Sorry, could not get a clear answer in a search.
  7. cpscdave

    MySQL: Best way to warehouse older data

    Hi everyone, I have a MySQL DB with a couple of large tables (a couple hundred million rows). Each row has a timestamp associated with it. Since this is just historical data, and not needed we want to copy older data into another database, and then delete the copied records. I've written a...
  8. A

    Help importing Northwind db to mysql

    Hi, I am having problems importing the Northwind database https://msdn.microsoft.com/en-us/library/bb399411(v=vs.110).aspx into mysql on my machine. I'm running wamp64 and mysgl ver 5.7.14. When I download the files, I obtain instnwnd.sql file. However, when I use phpMyAdmin and attempt to...
  9. cpscdave

    Locating MySQL .ini File from the Command Line - Dave's Search

    I found this before out on the interwebs, but alas can't find it today. How can you print the location of the .ini file that MySQL is using from the MySQL command line?? Thanks, -Dave
  10. W

    MySQL DDL Column Edit is Disabled. Why?

    Hi All, I am using MySQL in order to design an ERD (Entity Relation Diagram) , and I can make use of indexes, triggers, etc. but for some reason, the columns tab , which allows me to add data or just edit the tables is disabled. I have searched online without success. Any ideas on how to enable...
  11. W

    Can we Draw Dependency Diagrams in MySqL?

    Hi all, I am given a data table, with dependencies. Can I use MS MySQL workbench to draw the associated dependency diagram? Thanks.
  12. Stephanus

    PHP Learning Web Programming: MySQL & PHP for Complex Websites

    Dear PF Forum, I want to learn web programming, but there are specifics information that I need to know. What is the most famous database in web programming? My SQL? Is it true that PF Forum database is MySQL? If this is true, then the conclusion is MySQL can handle millions of post, hundreds...
  13. infinite.curve

    Connecting mySQL to Ruby on NETBEAN 8.0

    So... I hae this issue trying to connect mySQL to ruby on net bean... Has anyone connected it before? The code: #!/user/bin/ruby require 'mysql' begin puts "hello World" con = Mysql.new 'localhost', 'sqluser', '' puts con.get_server_info rs = con.query...
  14. adjacent

    Offline Server Software for Making Changes & Uploading | MySQL Supported

    I have a website but it's very difficult to make changes online because you can't change what you did.So I just want to make required changes offline and later upload it.So is there any good offline server software? I also want Mysql I tried Mr.Google but couldn't find anything helpful
  15. E

    MySQL: Using Aliases & Old Names

    If you rename an attribute or a relation with the keyword AS in MYSQL can you use the alias created outside the query where you renamed the attribute, also can you use the old name?
  16. S

    Is MySQL a programming language for databases?

    I'm confused about whether MySQL is an actual language you program in or whether it is just an environment or IDE. Or is PHP what you write in Mysql or can you write any language in MySQL. Can someone explain this to me? please let me know if I haven't explained my question clearly enough.
  17. H

    Does Microsoft have a free version of MySQL?

    I am wanting to gain experience with SQL without buying a license. I am planning to buy a program that shows you how to create databases as well as write code for them. However, this program requires that I have an SQL setup to use. I saw that Microsoft has a MySQL download but I'm not sure...
  18. C

    MySQL: Schema & Model Explained - Self-Learning Guide

    Hi, I am self learning MySQL, I am a bit confuse with the terminology, can someone explain a little bit what is schema and model? And how they are usually used? Thanks.
  19. Doc Al

    MySQL GUI for Solaris 10?

    Anyone know of a GUI for MySQL that would work with the Solaris 10 OS? (Free is always good.)
  20. C

    Getting Started with MySQL: Advice for Beginners

    hey everyone, I'm about to take an introductory course in databases in the fall, but I figured I could start learning about them now. I downloaded & installed MySQL Server 5.1, but I'm not exactly sure what to do at this point. I'll migrate to the bin folder and type in the following...
  21. M

    PHP Dynamic Website (PHP & MySQL)

    Hi, I already have a static website, and now I am trying to design a dynamic website. I used Apache, PHP, and MySQL and setup on my computer (hostname = localhost) and tested my member directory database. It worked fine that I can add, edit and delete, and update the data from table. I...
  22. I

    Accessing MDF & LDF Files in MS SQL Server 2005

    Hello, I have never used SQL before and I have a .mdf & a .ldf file and I need to change some parameters. Is there a way to view them like an Access Database? I have Microsoft SQL Server 2005, but to my knowledge there is no utility included to access these files. Thanks
  23. F

    PHP Multiplayer game using PHP and mysql

    I am designing a map game, using PHP and MYSQL. I don't know how to make the players who sign-in to the website to see other players who are also connected to the site and be able to chat with one another. I want to design the game in such a way that 2 players can play with each other and...
  24. R

    MySQL: Logging SQL Statements for Debugging PHP Apps

    Goal: I seek to log the SQL statements into a MySQL table, with the time they were executed as an aid to debugging problems with PHP apps I am writing. Problem: MySQL seems to try to interpret the statement, meant to simply be data in a field. When I try to "INSERT" the values, I get MySQL...
  25. N

    PHP Php to select data from the mysql database with chinese character

    I use php to select data from the mysql database with chinese character but when I echo it ,it show ? . I am sure the encoding is correct but it still don't show the chinese character . I am using IE 6 . Please help .
  26. K

    PHP Searching PHP & MySQL: Roots, Prefixes, & Suffixes

    Hi everyone, I'm just beginning to learn php, but I'm working on a small script where I'm trying to search a few fields in a table and if the values match, other fields in the same row are displayed. The db has just one table with 6 fields: ID (primary key), words, definitions, roots...
  27. N

    PHP How to create a online multiplayer games with mysql support using php ?

    I want to create a online multiplayer games with php but I don't know how to let the members know their opponents' move realtime ? Please help me !Thanks
  28. C

    Granting Access to MySQL Server on OS X for Network Clients

    I have a MySQL server on OS X and I want to make it so that it accepts client loggins from my laptop on teh network. how do I make it so that it will allow my laptop to connect? Thanks
  29. dduardo

    [MySQL] Fulltext Wildcards

    Do you guys know if it is possible to use pre-appended wildcards when doing a fulltext search? Is there a workaround that I could possibly use? I've read through the documentation and it seems as if you can only do appended wildcards. Here is my query: $query = "SELECT title, MATCH (title)...