Welcome to World of IPTV

With

+23k members
+11k threads
+106k posts

we are the most popular IPTV community on the web. 

IMPORTANT NOTE:
WE HAVE RECENTLY NOTICED THAT TOO MANY DOUBLE FAKE ACCOUNTS ARE CREATED IN THE PAST.
TO PREVENT THIS ISSUE THE DECISION WAS MADE THAT IN THE FUTURE A ANNUALLY FEE 20 EURO WILL BE RAISED FOR NEW MEMBERSHIPS.

Join now to the World of IPTV

Forum Rules

Before you start, check out the forum rules first

Account upgrade

Upgrade your account to get access to full features

Advertising

Would you like to place your advertisement with us ?

Resources Manager

Hundreds of IPTV scripts and apps are available for download

Reset root MySQL password on Ubuntu 18.04 Bionic Beaver Linux

redhat

Administrator
Staff member
Administrator
Chief Moderator
Moderator
Joined
Jun 19, 2019
Messages
3,066
Reaction score
14,798
Points
134
Location
root[@]woi
Objective
The objective is to reset lost root MySQL password on Ubuntu 18.04 Bionic Beaver Linux

Operating System and Software Versions
  • Operating System: - Ubuntu 18.04 Bionic Beaver
  • Software: - mysql Ver 14.14 or higher
Requirements
Privileged access to your Ubuntu System as root or via sudo command is required.

Difficulty
EASY

Conventions
  • # - requires given linux commands to be executed with root privileges either directly as a root user or by use of sudo command
  • $ - requires given linux commands to be executed as a regular non-privileged user

Instructions
Reset by using mysql_secure_installation

The simplest approach to reset MySQL database root password is to execute mysql_secure_installation program and when prompted entering your new root MySQL password:

PHP:
$ sudo mysql_secure_installation

....

Please set the password for root here.


New password:

Re-enter new password:


Reset by using skip-grant-tables
If from some reason the above method fails follow the step below to use --skip-grant-tables to reset MySQL root password.

Let's start by stopping the currently running MySQL database: $ sudo service mysql stop


Next, create a /var/run/mysqld directory to be used by MySQL process to store and access socket file:
Bash:
$ sudo mkdir -p /var/run/mysqld

$ sudo chown mysql:mysql /var/run/mysqld


Once ready manually start MySQL with the following linux command and options:
Bash:
$ sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &

$ [1] 2708


Confirm that the process is running as expected:
Bash:
$ jobs

[1]+  Running     sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &
 
Channels MatchTime Unblock CDN Offshore Server Contact
100 cnx / 90€ 5Gbps / 180€ 48CPU-256GRAM 10Gbps 569€ Skype live:giefsl
500 cnx / 350€ 10Gbps / 350€ 48CPU-128GRAM 5Gbps / 349€ TG @changglobize
1000 cnx / 500€ 20Gbps / 700€ 40CPU-128GRAM 20Gbps / €980 http://coronaserver.com
shape1
shape2
shape3
shape4
shape5
shape6
Top
AdBlock Detected

We know, ad-blocking software do a great job at blocking ads. But our site is sponsored by advertising. 

For the best possible site experience please take a moment to disable your AdBlocker.
You can create a Account with us or if you already have account, you can prefer an Account Upgrade.

I've Disabled AdBlock