+ Post New Thread
Results 1 to 13 of 13
Windows Server 2000/2003 Thread, Firewall & MySQL Setup in Technical; OK, from my thread in Web Development I managed to get IIS6 and PHP working. Just trying MySQL now and ...
  1. #1

    Join Date
    Apr 2007
    Location
    Ramsbottom, Bury, Lancs
    Posts
    581
    Thank Post
    11
    Thanked 5 Times in 5 Posts
    Rep Power
    20

    Firewall & MySQL Setup

    OK, from my thread in Web Development I managed to get IIS6 and PHP working.
    Just trying MySQL now and when it installs it gives an error saying it can't connect to root@localhost on post 3306.
    I've added the port to exceptions on Windows firewall but the firewall is actually turned off. At the bottom of the firewall it says "Managed by non-domain settings". I guess there is another firewall operating. I'm using Symantec Corperate but that is just the AntiVirus.

  2. #2

    Join Date
    Apr 2007
    Location
    Ramsbottom, Bury, Lancs
    Posts
    581
    Thank Post
    11
    Thanked 5 Times in 5 Posts
    Rep Power
    20
    Just to add the message is "access denied" for user root@localhost

  3. #3

    Join Date
    May 2006
    Location
    West Bromwich
    Posts
    2,192
    Thank Post
    300
    Thanked 215 Times in 185 Posts
    Rep Power
    57
    password for root maybe?

  4. #4

    Join Date
    Apr 2007
    Location
    Ramsbottom, Bury, Lancs
    Posts
    581
    Thank Post
    11
    Thanked 5 Times in 5 Posts
    Rep Power
    20
    Yeah thats the problem.
    Removed MySQL and started again. WHen it comes to setting password, if needs the current root password which I put in, but then I want the new one to be blank but it doesn't allow it. Is there a way to remove password totally ?

  5. #5

    Join Date
    May 2006
    Location
    West Bromwich
    Posts
    2,192
    Thank Post
    300
    Thanked 215 Times in 185 Posts
    Rep Power
    57
    Why would you want the root password to be blank?
    It really should be secure the root password.

    As for your question i am not too sure. You could download the mysql admin tools. I use these quite a lot since i am a DB newb.

    Works most of the time for me.

  6. #6

    Join Date
    Apr 2007
    Location
    Ramsbottom, Bury, Lancs
    Posts
    581
    Thank Post
    11
    Thanked 5 Times in 5 Posts
    Rep Power
    20
    Yeah I've got the admin tools and can log on with root and no password. Trying to install Joomla but it doesn't reconise mysql is running

  7. #7


    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    4,507
    Thank Post
    871
    Thanked 862 Times in 681 Posts
    Rep Power
    199
    GRANT ALL ON mydb TO 'root'@'localhost' IDENTIFIED BY PASSWORD "";
    FLUSH PRIVILEGES;

    should do it if you are able to access mysql from the commandline.
    See also: MySQL :: MySQL 5.1 Reference Manual :: 12.5.1.3 GRANT Syntax

    Suggest however that you *Should* use a root password, and that whatever web app you are using will allow you to specify this in some config file or other.

  8. #8

    Join Date
    Apr 2007
    Location
    Ramsbottom, Bury, Lancs
    Posts
    581
    Thank Post
    11
    Thanked 5 Times in 5 Posts
    Rep Power
    20
    Thanks Tom.
    Got to going now with no errors on installation - can connect via admintools to database.
    Just struggling with Joomla setup now as it says there is no sql !!

  9. #9

    Join Date
    May 2006
    Location
    West Bromwich
    Posts
    2,192
    Thank Post
    300
    Thanked 215 Times in 185 Posts
    Rep Power
    57
    what does php info say about the MySQl installation? It may be commented out in the php.ini

  10. #10

    Join Date
    Apr 2007
    Location
    Ramsbottom, Bury, Lancs
    Posts
    581
    Thank Post
    11
    Thanked 5 Times in 5 Posts
    Rep Power
    20
    PHPinfo says nothing about mysql - screen below.

    This is mysql section of php.ini

    [MySQL]
    ; Allow or prevent persistent links.
    mysql.allow_persistent = On

    ; Maximum number of persistent links. -1 means no limit.
    mysql.max_persistent = -1

    ; Maximum number of links (persistent + non-persistent). -1 means no limit.
    mysql.max_links = -1

    ; Default port number for mysql_connect(). If unset, mysql_connect() will use
    ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
    ; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
    ; at MYSQL_PORT.
    mysql.default_port =3306

    ; Default socket name for local MySQL connects. If empty, uses the built-in
    ; MySQL defaults.
    mysql.default_socket =

    ; Default host for mysql_connect() (doesn't apply in safe mode).
    mysql.default_host =localhost

    ; Default user for mysql_connect() (doesn't apply in safe mode).
    mysql.default_user =root

    ; Default password for mysql_connect() (doesn't apply in safe mode).
    ; Note that this is generally a *bad* idea to store passwords in this file.
    ; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
    ; and reveal this password! And of course, any users with read access to this
    ; file will be able to reveal the password as well.
    mysql.default_password =********

    ; Maximum time (in seconds) for connect timeout. -1 means no limit
    mysql.connect_timeout = 60

    ; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
    ; SQL-Errors will be displayed.
    mysql.trace_mode = Off
    Attached Images Attached Images

  11. #11

    Join Date
    May 2006
    Location
    West Bromwich
    Posts
    2,192
    Thank Post
    300
    Thanked 215 Times in 185 Posts
    Rep Power
    57
    In the php.ini there should be an extensions section. In this section there is a long list of all the extensions php can use. most if not all are commented out. MySQL needs to be uncommented by removing the semi colon from the front of the line that reads ;mysql.dll i think it is.

    I may be barking up the wrong tree entirely though as it has been years since i did this stuff on a Windows box. You may also need to make sure that the extension is indeed there.
    Attached Images Attached Images

  12. #12

    Join Date
    May 2006
    Location
    West Bromwich
    Posts
    2,192
    Thank Post
    300
    Thanked 215 Times in 185 Posts
    Rep Power
    57
    I think you may also need to restart the web service after enabling the extension if needed.

  13. #13

    Join Date
    Apr 2007
    Location
    Ramsbottom, Bury, Lancs
    Posts
    581
    Thank Post
    11
    Thanked 5 Times in 5 Posts
    Rep Power
    20
    Ok, enabled the extension in php.ini but Joomla still showing NO



SHARE:
+ Post New Thread

Similar Threads

  1. [Ubuntu] Setup FTP Users & Set Permissions
    By FN-GM in forum *nix
    Replies: 5
    Last Post: 18th February 2009, 01:21 PM
  2. Televic & Windows Firewall
    By tomlin in forum Windows
    Replies: 3
    Last Post: 13th May 2008, 07:44 PM
  3. csf firewall & whmsonic.
    By russdev in forum *nix
    Replies: 3
    Last Post: 28th December 2007, 03:40 PM
  4. using mysql & php on a W2K SP2 server
    By beeswax in forum Web Development
    Replies: 44
    Last Post: 29th June 2006, 09:54 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •