[HH#427838] root password for MySql

[HelioHost]

Username: smartcod, Server: Johnny, Main domain: smartcod.heliohost.org

 

Hello there, in the first place I have to thank you for your service.

Now I have another question, what is the password for "root" user.

I connect Workbench with your service using the userID I created when I

first create the database itself, which has full permissions. I tried to

create another "schema" with Workbench but it is not working. I tried

using phpMyAdmin and it worked well, I could create it with no problem.

As I understand it, I need to log on with root user/password when I use

WorkBench so I can get full privileges to do so.

I prefer using WorkBench because of two main reasons: slow internet and

not updated laptop. I live in Venezuela, as you probably know , we are

not doing very well, this country is falling apart. We have to use

whatever is available.

Thanks in advance, I appreciate your help.

 

Cesar

[wolstech]

You’re on a shared server that’s also used by thousands of other people, so we can’t give you that since it would let you access everyone else’s information.

 

If you really need root access to MySQL, you’d need to buy a vps instead: https://heliohost.org/vps/

 

You can create databases using cPanel and import the data though, so there should be no reason this is necessary for 99.9% of uses.

[HelioHost]

I also recently tried using the same usr/pwd that I use to Login HelioHost

with WorkBench and now I am able to see within the same session my two DB

Schemas, that works for me.

Thank you very much.

Best regards

 

El mie., 2 sept. 2020 a las 12:49, Heliohost Support ()

escribio:

 

> You're on a shared server that's also used by thousands of other people,

> so we can't give you that since it would let you access everyone else's

> information.

> If you really need root access to MySQL, you'd need to buy a vps instead:

> https://heliohost.org/vps/

> You can create databases using cPanel and import the data though, so there

> should be no reason this is necessary for 99.9% of uses.

>

> You may view the status of your ticket by visiting:

>

> https://www.helionet.org/index/index.php?showtopic=40912

>

> Thank you,

> Heliohost support

> https://www.heliohost.org/

> https://www.helionet.org/

>

>

[wolstech]

Yes that will work. The username and password you use for cpanel is the closest thing a user has to "root" on the shared server. That account has full access to all databases the user owns.