+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep2 Support (https://lckb.dev/forum/forumdisplay.php?fid=166)
+------ Forum: Solved Topics (https://lckb.dev/forum/forumdisplay.php?fid=144)
+------ Thread: [Solved] Mysql Permissions? (/showthread.php?tid=2773)
- lukaslt - 11-29-2013
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 - 11-29-2013
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 - 11-29-2013
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 - 11-29-2013
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 - 11-29-2013
oki try thes guid here i tested it and worked
2
- lukaslt - 11-29-2013
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 - 11-30-2013
Im glad you solved it
Ill close and put it in solved section ^^
- Johnny5 - 11-30-2013
A moderator closed this post. Reason: Topic Solved. Move to solved section