Jump to content

Start Time: 01/03/2022 12:00 AM <> End Time: 08/09/2022 10:34 PM

If you want to buy VIP Member, Please click here to buy

---------------------------------------------------------------------

Benefits when you are a VIP Member

---------------------------------------------------------------------

Click to Dismiss this Notification
×
×
  • Create New...

Buy VIP Membership now!

If you want to download premium resources you have to buy VIP!

Buy now VIP Resources

Advertise with us

Advertise here for only 25 euros per month

Buy now Contact

[MYSQL] How to create new mysql user


Umbra
 Share

Recommended Posts

 

Hi there, I saw that many do not know how to create a new user and I decided to tell you how to do this.

First reset mysql password.

1

Hidden Content

    Give reaction to this post to see the hidden content.

2

Hidden Content

    Give reaction to this post to see the hidden content.

3

Hidden Content

    Give reaction to this post to see the hidden content.

4

Hidden Content

    Give reaction to this post to see the hidden content.

5

Hidden Content

    Give reaction to this post to see the hidden content.

6

Hidden Content

    Give reaction to this post to see the hidden content.

7

Hidden Content

    Give reaction to this post to see the hidden content.

8

Hidden Content

    Give reaction to this post to see the hidden content.

Now that we have changed the root user password we can create a new user.
Also in putty we write the following

1

Hidden Content

    Give reaction to this post to see the hidden content.

We will be prompted to enter a password, enter the password set in step 5 above.

3

Hidden Content

    Give reaction to this post to see the hidden content.

4

Hidden Content

    Give reaction to this post to see the hidden content.

5

Hidden Content

    Give reaction to this post to see the hidden content.

6

Hidden Content

    Give reaction to this post to see the hidden content.

And that was all, now you can log in on Navicat

  • Like 26
  • Thanks 4
  • Confused 3
  • Sad 3
Link to post
Share on other sites

  • 3 weeks later...
  • 1 month later...
  • 2 weeks later...
  • 2 weeks later...
  • 1 month later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share