• 0

Mysql Problems


Question

Hello

I am running Red Hat 8 with Apache & mySQL, i've got a copy of PremiumSoft MySQL Studio but when I enter my details, it says it cannot connect?

My Intranet site is running fine, and mySQL is running OK, the username and password are correct but mySQL Studio says it cannot connect as "root@10.44.16.191"

Can anyone help?

Thanks

Ben :)

Link to comment
https://www.neowin.net/forum/topic/53185-mysql-problems/
Share on other sites

12 answers to this question

Recommended Posts

  • 0

It may be a firewall/configuration error, try the following and let me know if it helps:

1) Create a custom firewall rule enabling port 3306 access by logging it as root and typing "lokkit" then restart iptables via "/etc/rc.d/init.d/iptables restart" or "/etc/rc.d/init.d/ipchains restart"

2) Modify /etc/rc.d/init.d/mysqld and replace '--skip-networking' with '--port=3306'

3) Start the daemon up via "$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --port=3306 &"

4) Log in as root to mysql (mysql -u root -p) and grant permissions to the database you want i.e. GRANT ALL PRIVILEGES ON dbname.* TO 'username'@'serverip' identified by 'password';

5) Restart MySQL and all should be good.

Good luck!

Link to comment
https://www.neowin.net/forum/topic/53185-mysql-problems/#findComment-529892
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • "The company has recently announced the forming of a new agentic AI team to develop an agentic AI framework for use in robotics." I wonder if any of their executives attented, "Microsoft Build 2025" last month?
    • Microsoft Build conference to leave Seattle after years in the city by Pradeep Viswanathan Microsoft Build is a flagship annual developer conference held by Microsoft since 2011. In 2017, Microsoft relocated Build from San Francisco to its home turf in Seattle. The proximity to its main campus allowed greater participation from its own engineers and executives, offering attendees a more integrated experience. Today, Jonathan Choe revealed on X that Microsoft has decided to move its Build developer conference out of Seattle. He discovered this information via an email sent by Visit Seattle to its members. Visit Seattle is a private, non-profit destination marketing organization that promotes travel to Seattle and King County. As a result of the move, Seattle-based hotels could lose approximately 9,314 room nights annually. Surprisingly, Visit Seattle’s message included several details about Microsoft’s reasons for the change. The primary reason appears to have come from within Microsoft itself. The company feels that Build lost momentum post-COVID, and the scheduling conflict with Google I/O, a competing event, has made it harder to attract the intended audience. Microsoft’s leadership believes they can better re-energize the program and boost attendance by moving it out of Seattle. The note even suggests that Build will likely be relocated to San Francisco or Las Vegas in 2026. Another factor contributing to the decision is the condition of the city. Last month, during the conference, Microsoft leadership and attendees walked between the Hyatt Regency and the Arch building on 8th Street. Reportedly, there were complaints about the general uncleanliness of the area, the visible presence of individuals using drugs, and unhoused individuals in a recurring tent in the Arch Tunnel. Visit Seattle believes these concerns also played a role in Microsoft’s final decision to relocate Build. Given Microsoft's high-profile presence and the economic impact of the event, this relocation may spark a political storm within the Seattle mayor’s office, drawing criticism over the city’s handling of downtown conditions.
    • This is very exciting, happy to see it come back to RC.
    • What did you have to do for that? Are the steps similar to W10?
  • Recent Achievements

    • Week One Done
      daelos earned a badge
      Week One Done
    • One Month Later
      daelos earned a badge
      One Month Later
    • Mentor
      Karlston went up a rank
      Mentor
    • One Month Later
      EdwardFranciscoVilla earned a badge
      One Month Later
    • One Month Later
      MoyaM earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      491
    2. 2
      snowy owl
      252
    3. 3
      +FloatingFatMan
      251
    4. 4
      ATLien_0
      216
    5. 5
      +Edouard
      160
  • Tell a friend

    Love Neowin? Tell a friend!