Access MySQL as root or reset its password

Paolo Caparrelli DBMS 22 June 2022

service mysql stop

mysqld_safe --skip-grant-tables &

mysql -u root



USE mysql

UPDATE user SET Password = PASSWORD('password1234')

WHERE Host = '%' AND User = 'root';

FLUSH PRIVILEGES;

service mysql start



Then log in with root like this: mysql -p

and write the password

DB list via SQL: show databases;

Delete a database via SQL: drop ;

Create database via SQL: create database ;

0 0 votes

Article Rating

0 Comments

Oldest

Newest Most Voted

Home

About Us

Services

Solutions

Systems Architecture

Support

FAQ

News

GOLINE Achieves ESET Gold Partner Status for 2027 October 2nd, 2026

GOLINE is pleased to announce that it has achieved ESET Gold Partner status for 2027. The recognition follows the successful completion of ESET’s partner certification requirements and confirms GOLINE’s continued investment in cybersecurity expertise and professional development. ESET’s partner programme is designed to support companies working with its cybersecurity solutions through dedicated technical and sales resources, training and other partner services. For GOLINE, the achievement further strengthens its collaboration with ESET and its ability to integrate ESET security technologies into the cybersecurity solutions and services it provides to businesses. ESET solutions are already part of GOLINE’s cybersecurity portfolio, alongside technologies...
GOLINE SA Announces Strategic Partnership with NetApp November 7th, 2025

GOLINE SA is excited to announce a new partnership with NetApp, a global leader in cloud data services and storage solutions. This collaboration aims to help organizations modernize their IT infrastructure, streamline data management, and enhance performance across cloud and hybrid environments. Modern Data Solutions for Businesses Through this partnership, GOLINE integrates advanced data management solutions, enabling businesses to securely store, manage, and access critical information across cloud, on-premises, or hybrid setups. Clients can benefit from: Flexible and scalable storage solutions to meet growing data needs Simplified management of cloud and on-premises environments Enterprise-grade security for sensitive and mission-critical data...
GOLINE SA Announces Partnership with Omnissa November 7th, 2025

GOLINE SA is proud to announce a new strategic partnership with Omnissa, a global leader in digital workspace platforms and Horizon Cloud Service solutions. This collaboration marks a significant step forward in helping organizations embrace secure, flexible, and high-performance work environments. Why Choose Omnissa for Your Business? The platform enables virtual desktops, applications, and unified endpoint management. Organizations can deploy scalable workspaces across cloud, hybrid, or on-premises setups. Key benefits include: Easy access to desktops and apps on any device Centralized management for Windows, macOS, iOS, Android, and ChromeOS Strong security with access controls and multi-factor authentication Automated scaling to...

Would love your thoughts, please comment.x

()

| Reply