• 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

    • Everything's OK! 🤣🤣🤣  
    • XnView 2.52.2 by Razvan Serea XnView is freeware software that allows you to view and convert graphic files. It's very fast and easy to use. But more importantly it supports more than 500 graphics formats! Import about 500 graphic file formats Export about 50 graphic file formats Multipage TIFF, Animated GIF, Animated ICO support Image IPTC, EXIF metadata support EXIF auto rotation support IPTC editing Resize, rotate, crop support Lossless rotate & crop (jpeg) support Adjust brightness, contrast... Auto levels, contrast Modify number of colors Apply filters (blur, average, emboss, ...) Apply effects (lens, wave, ...) Fullscreen mode Slide show with effects Batch convert, batch rename Create WEB page easily Screen capture Create contact Sheet Create or edit Multi-page file (TIFF, DCX, LDF) TWAIN & WIA support (Windows only) Print support (Windows only) Drag & Drop support (Windows only) Compare image side by side Filmstrip layout 44 languages support (Windows only) XnView 2.52.2 changelog: NConvert: -xyb for JPEGli XnView vs XnView MP: XnView is the classic, lightweight version with basic features and Windows-only support. XnView MP is the modern, cross-platform version with an improved interface, better performance, and extended format support. Download: XnView 2.52.2 Installer | Standalone | ~24.0 MB (Non-commercial freeware) Download: XnView MP 1.9.2 64-bit | Standalone | ~100.0 MB Download: XnView MP 1.9.2 32-bit | Standalone | ~60.0 MB View: XnView Website | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • Correct. You don’t buy anything that’s free (if it were).
    • Vivaldi 7.4.3684.52 by Razvan Serea Vivaldi is a cross-platform web browser built for – and with – the web. A browser based on the Blink engine (same in Chrome and Chromium) that is fast, but also a browser that is rich in functionality, highly flexible and puts the user first. A browser that is made for you. Vivaldi is produced with love by a founding team of browser pioneers, including former CEO Jon Stephenson von Tetzchner, who co-founded and led Opera Software. Vivaldi’s interface is very customizable. Vivaldi combines simplicity and fashion to create a basic, highly customizable interface that provides everything a internet user could need. The browser allows users to customize the appearance of UI elements such as background color, overall theme, address bar and tab positioning, and start pages. Vivaldi features the ability to "stack" and "tile" tabs, annotate web pages, add notes to bookmarks and much more. Vivaldi 7.4.3684.52 changelog: [Address bar] URL is searched instead of opening (VB-117198) [Chromium] Update to 136.0.7103.179 [Settings][Workspaces] Add Workspace Rule button hidden by 4th rule (VB-117181) Download: Vivaldi 64-bit | 125.0 MB (Freeware) Download: Vivaldi 32-bit | ARM64 View: Vivaldi Home Page | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
  • Recent Achievements

    • Week One Done
      Wayne Robinson earned a badge
      Week One Done
    • One Month Later
      Karan Khanna earned a badge
      One Month Later
    • Week One Done
      Karan Khanna earned a badge
      Week One Done
    • First Post
      MikeK13 earned a badge
      First Post
    • Week One Done
      OHI Accounting earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      687
    2. 2
      ATLien_0
      268
    3. 3
      Michael Scrip
      202
    4. 4
      +FloatingFatMan
      169
    5. 5
      Steven P.
      142
  • Tell a friend

    Love Neowin? Tell a friend!