{"id":7929,"date":"2024-06-01T09:55:45","date_gmt":"2024-06-01T04:25:45","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=7929"},"modified":"2026-08-18T08:59:37","modified_gmt":"2026-08-18T03:29:37","slug":"setup-mysql-create-user-ubuntu-24-04","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/setup-mysql-create-user-ubuntu-24-04\/","title":{"rendered":"How to setup MySQL and create a user on Ubuntu 24.04?"},"content":{"rendered":"\n

Introduction:<\/strong><\/p>\n\n\n\n

In today\u2019s digital landscape, setting up and managing databases is a crucial aspect of many software projects. Among the most popular database management systems is MySQL, renowned for its reliability and scalability. This guide will walk you through the process of installing MySQL on Ubuntu 24.04, along with creating a new user to facilitate secure access to the database.<\/p>\n\n\n\n

Prerequisites:<\/strong><\/p>\n\n\n\n

Before proceeding with the installation, ensure that you have administrative access to an Ubuntu 24.04 server or workstation. Additionally, make sure your system is up to date by running the following commands:<\/p>\n\n\n\n

sudo apt update<\/p>\n\n\n\n

sudo apt upgrade<\/p>\n\n\n\n

Installation:<\/strong><\/p>\n\n\n\n

To install MySQL on Ubuntu 24.04, execute the following command:<\/p>\n\n\n\n

sudo apt install mysql-server<\/p>\n\n\n\n

Once the installation is complete, MySQL will be automatically started. However, we need to make a slight adjustment to the user authentication method to enhance security.<\/p>\n\n\n\n

Modify User Authentication Method:<\/strong><\/p>\n\n\n\n

By default, MySQL uses a caching_sha2_password authentication plugin, which may not be compatible with certain applications. To ensure compatibility and simplicity, we will switch the authentication method for the root user to mysql_native_password. Execute the following command:<\/p>\n\n\n\n

sudo mysql -e “ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘your_password’;”<\/p>\n\n\n\n

Replace ‘your_password’ with the desired password for the root user.<\/p>\n\n\n\n

Create a New Database and User:<\/strong><\/p>\n\n\n\n

Now, let\u2019s create a new MySQL user with limited privileges and a database for them. For demonstration purposes, let\u2019s create a user named ‘sam’ with the password ‘2114’ and a database named ‘example_db’. Execute the following commands:<\/p>\n\n\n\n

sudo mysql -u root -p<\/p>\n\n\n\n

Enter the password of root user and run the following commands in mysql:<\/p>\n\n\n\n

CREATE DATABASE example_db;<\/p>\n\n\n\n

CREATE USER ‘sam’@’localhost’ IDENTIFIED BY ‘2114’;<\/p>\n\n\n\n

GRANT ALL PRIVILEGES ON example_db.* TO ‘sam’@’localhost’;<\/p>\n\n\n\n

FLUSH PRIVILEGES;<\/p>\n\n\n\n

exit<\/p>\n\n\n\n

Conclusion:<\/strong><\/p>\n\n\n\n

You have successfully installed MySQL on your Ubuntu 24.04 system and created a new user for database access. Remember to replace ‘your_password’ and ‘2114’ with strong, secure passwords of your choice. With MySQL up and running, you\u2019re well-equipped to leverage the power of databases in your projects.<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction: In today\u2019s digital landscape, setting up and managing databases is a crucial aspect of many software projects. Among the most popular database management systems is MySQL, renowned for its reliability and scalability. This guide will walk you through the process of installing MySQL on Ubuntu 24.04, along with creating… Continue Reading How to setup MySQL and create a user on Ubuntu 24.04?<\/span><\/i><\/a><\/p>\n","protected":false},"author":508,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[386,225,387,282],"tags":[],"class_list":{"0":"post-7929","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-database","7":"category-linux","8":"category-mysql-database","9":"category-ubuntu","10":"h-entry","12":"h-as-article"},"yoast_head":"\nSetup MySQL & Create a User on Ubuntu 24.04<\/title>\n<meta name=\"description\" content=\"Learn how to install MySQL and create a new user on Ubuntu 24.04, with step-by-step commands for beginners.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pheonixsolutions.com\/blog\/setup-mysql-create-user-ubuntu-24-04\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setup MySQL & Create a User on Ubuntu 24.04\" \/>\n<meta property=\"og:description\" content=\"Learn how to install MySQL and create a new user on Ubuntu 24.04, with step-by-step commands for beginners.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pheonixsolutions.com\/blog\/setup-mysql-create-user-ubuntu-24-04\/\" \/>\n<meta property=\"og:site_name\" content=\"PHEONIXSOLUTIONS\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-01T04:25:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-18T03:29:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/09\/PX2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"3837\" \/>\n\t<meta property=\"og:image:height\" content=\"2540\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"srisanthosh S\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:site\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"srisanthosh S\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/setup-mysql-create-user-ubuntu-24-04\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/setup-mysql-create-user-ubuntu-24-04\\\/\"},\"author\":{\"name\":\"srisanthosh S\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/09ea76d3244c951605c4850771aa1d97\"},\"headline\":\"How to setup MySQL and create a user on Ubuntu 24.04?\",\"datePublished\":\"2024-06-01T04:25:45+00:00\",\"dateModified\":\"2026-08-18T03:29:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/setup-mysql-create-user-ubuntu-24-04\\\/\"},\"wordCount\":352,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"articleSection\":[\"Database\",\"Linux\",\"Mysql\",\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/setup-mysql-create-user-ubuntu-24-04\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/setup-mysql-create-user-ubuntu-24-04\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/setup-mysql-create-user-ubuntu-24-04\\\/\",\"name\":\"Setup MySQL & Create a User on Ubuntu 24.04\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\"},\"datePublished\":\"2024-06-01T04:25:45+00:00\",\"dateModified\":\"2026-08-18T03:29:37+00:00\",\"description\":\"Learn how to install MySQL and create a new user on Ubuntu 24.04, with step-by-step commands for beginners.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/setup-mysql-create-user-ubuntu-24-04\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/setup-mysql-create-user-ubuntu-24-04\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/setup-mysql-create-user-ubuntu-24-04\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to setup MySQL and create a user on Ubuntu 24.04?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"name\":\"Pheonix Solutions\",\"description\":\"We Empower Your Business Growth\",\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\",\"name\":\"PheonixSolutions\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"width\":454,\"height\":300,\"caption\":\"PheonixSolutions\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/PheonixSolutions-209942982759387\\\/\",\"https:\\\/\\\/x.com\\\/pheonixsolution\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/09ea76d3244c951605c4850771aa1d97\",\"name\":\"srisanthosh S\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6aaff236b178a614b2cfa9b0388af65e26cb08bb19608a622574904d2765036d?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6aaff236b178a614b2cfa9b0388af65e26cb08bb19608a622574904d2765036d?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6aaff236b178a614b2cfa9b0388af65e26cb08bb19608a622574904d2765036d?s=96&r=g\",\"caption\":\"srisanthosh S\"},\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/author\\\/srisanthosh\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Setup MySQL & Create a User on Ubuntu 24.04","description":"Learn how to install MySQL and create a new user on Ubuntu 24.04, with step-by-step commands for beginners.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/pheonixsolutions.com\/blog\/setup-mysql-create-user-ubuntu-24-04\/","og_locale":"en_US","og_type":"article","og_title":"Setup MySQL & Create a User on Ubuntu 24.04","og_description":"Learn how to install MySQL and create a new user on Ubuntu 24.04, with step-by-step commands for beginners.","og_url":"https:\/\/pheonixsolutions.com\/blog\/setup-mysql-create-user-ubuntu-24-04\/","og_site_name":"PHEONIXSOLUTIONS","article_publisher":"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","article_published_time":"2024-06-01T04:25:45+00:00","article_modified_time":"2026-08-18T03:29:37+00:00","og_image":[{"width":3837,"height":2540,"url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/09\/PX2.png","type":"image\/png"}],"author":"srisanthosh S","twitter_card":"summary_large_image","twitter_creator":"@pheonixsolution","twitter_site":"@pheonixsolution","twitter_misc":{"Written by":"srisanthosh S","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pheonixsolutions.com\/blog\/setup-mysql-create-user-ubuntu-24-04\/#article","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/setup-mysql-create-user-ubuntu-24-04\/"},"author":{"name":"srisanthosh S","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/09ea76d3244c951605c4850771aa1d97"},"headline":"How to setup MySQL and create a user on Ubuntu 24.04?","datePublished":"2024-06-01T04:25:45+00:00","dateModified":"2026-08-18T03:29:37+00:00","mainEntityOfPage":{"@id":"https:\/\/pheonixsolutions.com\/blog\/setup-mysql-create-user-ubuntu-24-04\/"},"wordCount":352,"commentCount":2,"publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"articleSection":["Database","Linux","Mysql","Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pheonixsolutions.com\/blog\/setup-mysql-create-user-ubuntu-24-04\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/pheonixsolutions.com\/blog\/setup-mysql-create-user-ubuntu-24-04\/","url":"https:\/\/pheonixsolutions.com\/blog\/setup-mysql-create-user-ubuntu-24-04\/","name":"Setup MySQL & Create a User on Ubuntu 24.04","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#website"},"datePublished":"2024-06-01T04:25:45+00:00","dateModified":"2026-08-18T03:29:37+00:00","description":"Learn how to install MySQL and create a new user on Ubuntu 24.04, with step-by-step commands for beginners.","breadcrumb":{"@id":"https:\/\/pheonixsolutions.com\/blog\/setup-mysql-create-user-ubuntu-24-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pheonixsolutions.com\/blog\/setup-mysql-create-user-ubuntu-24-04\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/pheonixsolutions.com\/blog\/setup-mysql-create-user-ubuntu-24-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pheonixsolutions.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to setup MySQL and create a user on Ubuntu 24.04?"}]},{"@type":"WebSite","@id":"https:\/\/pheonixsolutions.com\/blog\/#website","url":"https:\/\/pheonixsolutions.com\/blog\/","name":"Pheonix Solutions","description":"We Empower Your Business Growth","publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pheonixsolutions.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pheonixsolutions.com\/blog\/#organization","name":"PheonixSolutions","url":"https:\/\/pheonixsolutions.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","contentUrl":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","width":454,"height":300,"caption":"PheonixSolutions"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","https:\/\/x.com\/pheonixsolution"]},{"@type":"Person","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/09ea76d3244c951605c4850771aa1d97","name":"srisanthosh S","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/6aaff236b178a614b2cfa9b0388af65e26cb08bb19608a622574904d2765036d?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/6aaff236b178a614b2cfa9b0388af65e26cb08bb19608a622574904d2765036d?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6aaff236b178a614b2cfa9b0388af65e26cb08bb19608a622574904d2765036d?s=96&r=g","caption":"srisanthosh S"},"url":"https:\/\/pheonixsolutions.com\/blog\/author\/srisanthosh\/"}]}},"jetpack_shortlink":"https:\/\/wp.me\/p7F4uM-23T","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/508"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=7929"}],"version-history":[{"count":1,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7929\/revisions"}],"predecessor-version":[{"id":10839,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7929\/revisions\/10839"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=7929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=7929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=7929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}