tag:blogger.com,1999:blog-6850817271941197798.post7236634909207349862..comments2024-03-28T05:12:39.150-07:00Comments on Oracle DBA and RAC DBA Expert: Error 1130: #HY000 Host ‘hostname’ is not allowed to connect to this MySQL serverSatishbabu Gunukulahttp://www.blogger.com/profile/02630966486825083489noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6850817271941197798.post-86585183782346230532019-11-19T21:37:58.409-08:002019-11-19T21:37:58.409-08:00Looking for a job? Browse thousands of direct job ...Looking for a job? Browse thousands of direct job offers and find the best suitable position on Jobboss.co.uk. Job search for all jobs near me. Just apply for a job vacancy with one click.<br /><br />if you want more just look here "<a href="https://www.jobboss.co.uk//" rel="nofollow">jobboss</a>"jobbosshttps://www.blogger.com/profile/00341502891889985212noreply@blogger.comtag:blogger.com,1999:blog-6850817271941197798.post-8447894569785318202013-12-10T16:57:04.722-08:002013-12-10T16:57:04.722-08:00You should be able to connect MySQL Server as root...You should be able to connect MySQL Server as root and should be able to grant privileges<br /><br />Regards<br />SatishSatishbabu Gunukulahttps://www.blogger.com/profile/02630966486825083489noreply@blogger.comtag:blogger.com,1999:blog-6850817271941197798.post-30717675067864853742013-11-19T23:01:16.957-08:002013-11-19T23:01:16.957-08:00Dear Friends,
Because of host name issues, If you...Dear Friends,<br /><br />Because of host name issues, If you're not able to open to MySql prompt itself and seeing below error,<br />ERROR 1130 (HY000): Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server<br /><br />you might really stuck to apply above mentioned instructions. Then you can try below commands to overcome host name/localhost/127.0.0.1 naming issues and you'll be able to prompted @ MySql> and then you can grant permissions as mentioned above.<br /><br />mysql --no-defaults -h127.0.0.1 -uroot -p<br /><br />mysql --no-defaults -hlocalhost -uroot -p<br /><br />mysql --no-defaults -h -uroot -p<br /><br />One of above should work and prompts MySql to execute further queries.<br />Hope this helps.<br /><br />Best Regards,<br />Sandeep BashettiSandeephttps://www.blogger.com/profile/00045752493353526737noreply@blogger.com