Loading...
 
Skip to main content

Development

Forum List Topic List

Forums » Development » MySql Port
 
Thread actions
Print this page
  • Print all pages

    • MySql Port

    Posted by mercurio posts: 4 ☆

    Hi to everybody, I'm newer here and I use TikiWiki for my documentation.
    I installed a new version of mysql in standard port 3306, so I've changed the port of my old mysql with 3307. Now my Tiki wonts connect to my new MySql on 3306 but I've not import the old db on this.

    I should want, that my tikiwiki be connect at 3307, because Is better for me.

    Thanks for any helps.

    Luca

    Reads: 1248
    Posted by mercurio posts: 4 ☆

    Sorry, my dificoult stays in specify the port on local.php or in any other config files.

    Thanks again


    Posted by Danny Staple posts: 23 ☆ ☆ ☆ United Kingdom

    Have you tried adding colon port to the host specification in local.php? as in "host:port"? I don't know if it will work, but it is the first thing I would try.
    Further to that, I would examine the database connect code in php files that include local.php, by grepping for the host variable usage - you may get a clue from that and a php API reference.


    Posted by mercurio posts: 4 ☆

    Hi orionrobots, thanks for your help.
    Yes I've tried to do that, but the result is a message like this: 'Upgrade your mysql client.'


    Posted by mercurio posts: 4 ☆

    I've solved it with this command:

    UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
    -> WHERE Host = 'some_host' AND User = 'some_user';

    I read of a difficoult of php mysql client connecting to db higher than 4.1.

    Now it works fine.

    Thanks, bye. 😀