Jump to content
View in the app

A better way to browse. Learn more.

The Uniform Server Community

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Mysql username 'root'- server V5-Nano

Featured Replies

Hi guys, I have my uniform server V5-Nano up and running. In my security center all the status is secure.

I need to know is it possible to change my mysql username 'root'. How do I do it?

 

Will this action improve my security?

 

Thank you.. ;)

Jeret Christopher WEB DESIGNER

Great question, Jeret.

I checked this out a while back, and at that time, the answer was "yes and no." Yes you could do it, but it's a real pain and isn't necessary.

 

In reality, it's just like any other system that allows for multiple user accounts. Would you remove the Administrator account from your Windows machine? Probably not, but you *could* rename it to "admin" or "addy," right? In any case you DO need an account that has administration rights.

 

Now, in UniServer, root is the account that ties MySQL, phpMyAdmin and the UniServer admin control together for MySQL. If you'd like to change or redesign it, feel free, but it sure will make updates a challenge.

 

What is most practical IMHO is to put a really good password on root, then restrict access to the tools that use it to be only from the local machine. This means you actually have to be logged in to the controlling account before it will display your login screen.

 

Hope that's clear, ;)

BobS

  • Author

Great question, Jeret.

I checked this out a while back, and at that time, the answer was "yes and no." Yes you could do it, but it's a real pain and isn't necessary.

 

In reality, it's just like any other system that allows for multiple user accounts. Would you remove the Administrator account from your Windows machine? Probably not, but you *could* rename it to "admin" or "addy," right? In any case you DO need an account that has administration rights.

 

Now, in UniServer, root is the account that ties MySQL, phpMyAdmin and the UniServer admin control together for MySQL. If you'd like to change or redesign it, feel free, but it sure will make updates a challenge.

 

What is most practical IMHO is to put a really good password on root, then restrict access to the tools that use it to be only from the local machine. This means you actually have to be logged in to the controlling account before it will display your login screen.

 

Hope that's clear, ;)

BobS

 

 

Hi BobS,

 

It makes more sense now. Thank you... :o

Jeret Christopher WEB DESIGNER

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...

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.