[Solved] Mysql Permissions?

[lukaslt]

Hey guys,

 

Ive used today a tutorial of HateMe, (2)

Well it is everything fine but I am not allowed to remote access mysql from windows.

It says 1035 no permissions or something similar, anyways and another question is if its possible to remove root password, e.g. tried to mysql_secure_installation and i pressed Y trough a mistake, i would like to undo the password,

 

Thanks in advance,

 

Regards.

[systech]

What type of OS do you use? Centos Desktop?

Anyway, you gotta set up a mysql user into the server giving it host permision % which means allow from anywhere.

 

For removing the root password, you tried the command: passwd -d root

Basically it will remove the password

[lukaslt]

What type of OS do you use? Centos Desktop?

Anyway, you gotta set up a mysql user into the server giving it host permision % which means allow from anywhere.

 

For removing the root password, you tried the command: passwd -d root

Basically it will remove the password

 

I am pretty new in the stuff, I am using Centos how do you set up user, ive had a vmare on centos before, created users via navicat it was everything fine, well tried to install again and now theres no chances to connect to db from desktop. i can connect from centos its fine but it doesnt allow me to do it from desktop or from any tools

[systech]

So you use navicat on centos?

 

Simply connect to your mysql from centos using navicat, click on Users menu, then add a new one. 

In Hostname field put: %

Then put the username and password, save and switch to permissions tab, check them all and save

Now you should be able to connect to your mysql from desktop.

 

If you still cant, check out the firewall on your centos, opening the port: 3306

[SibaN]

oki try thes guid here i tested it and worked 

 

2

[lukaslt]

So you use navicat on centos?

 

Simply connect to your mysql from centos using navicat, click on Users menu, then add a new one. 

In Hostname field put: %

Then put the username and password, save and switch to permissions tab, check them all and save

Now you should be able to connect to your mysql from desktop.

 

If you still cant, check out the firewall on your centos, opening the port: 3306

 

Oh thanks, forgot about %. was putting my IP in it .

[systech]

Im glad you solved it

Ill close and put it in solved section ^^

[Johnny5]

A moderator closed this post. Reason: Topic Solved. Move to solved section