BugsLIFE Posted August 14, 2013 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 37 Reputation: 4 Joined: 06/07/13 Last Seen: April 27, 2022 Share Posted August 14, 2013 i tried to change 3306 to 3333 mysql port from my vps.. and now the flux cant connect to it.. anyone knows where can i change it flux? flux/config/server.php 'ServerName' => 'Server Name', // Global database configuration (excludes logs database configuration). 'DbConfig' => array( // 'Socket' => '/tmp/mysql.sock', // 'Port' => 3306, change it to 3333 and delete // didnt helped // 'Encoding' => 'utf8', // Connection encoding -- use whatever here your MySQL tables collation is. // 'Convert' => 'utf8', // -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available. // -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8) 'Hostname' => 'localhost', 'Username' => 'user', 'Password' => 'pass', 'Database' => 'ragnarok', 'Persistent' => true, 'Timezone' => 'Asia/Manila' // Example: '+0:00' is UTC. // The possible values of 'Timezone' is as documented from the MySQL website: // "The value can be given as a string indicating an offset from UTC, such as '+10:00' or '-6:00'." // "The value can be given as a named time zone, such as 'Europe/Helsinki', 'US/Eastern', or 'MET'." (see below continuation!) // **"Named time zones can be used only if the time zone information tables in the mysql database have been created and populated." ), // This is kept separate because many people choose to have their logs // database accessible under different credentials, and often on a // different server entirely to ensure the reliability of the log data. 'LogsDbConfig' => array( // 'Socket' => '/tmp/mysql.sock', //'Port' => 3306, change it to 3333 and delete // didnt helped // 'Encoding' => null, // Connection encoding -- use whatever here your MySQL tables collation is. // 'Convert' => 'utf8', // -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available. // -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8) 'Hostname' => 'localhost', 'Username' => 'user', 'Password' => 'pass', 'Database' => 'ragnarok', 'Persistent' => true, 'Timezone' => 'Asia/Manila' // Possible values is as described in the comment in DbConfig. ), Quote Link to comment Share on other sites More sharing options...
Asura Posted August 14, 2013 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 707 Reputation: 168 Joined: 01/26/12 Last Seen: February 7, 2014 Share Posted August 14, 2013 Hi BugsLIFE, Your MySQL has to be configured to run on port 3333, then restarted. But why would you change the port? You would have to do this for your emulator as well. FluxCP can't be set to query MySQL on port 3333 unless your MySQL server is actually listening to port 3333, by default; MySQL is set to use 3306. Quote Link to comment Share on other sites More sharing options...
ccjosh Posted August 15, 2013 Group: Members Topic Count: 13 Topics Per Day: 0.00 Content Count: 66 Reputation: 6 Joined: 11/13/12 Last Seen: November 17, 2014 Share Posted August 15, 2013 It's commented out. Remove "//" // 'Port' => 3306 Quote Link to comment Share on other sites More sharing options...
BugsLIFE Posted August 15, 2013 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 37 Reputation: 4 Joined: 06/07/13 Last Seen: April 27, 2022 Author Share Posted August 15, 2013 Hi BugsLIFE, Your MySQL has to be configured to run on port 3333, then restarted. But why would you change the port? You would have to do this for your emulator as well. FluxCP can't be set to query MySQL on port 3333 unless your MySQL server is actually listening to port 3333, by default; MySQL is set to use 3306. i tried to change it because i am scared of someone who use to ddos attack my server i thought he will target my vpsip+3306 port?.. or that will not work? about the mysql port yes it was working on my vps i check it using this lsof -i :3333 and it i see its LISTEN status It's commented out. Remove "//" // 'Port' => 3306 i already did that.. //'Port' => 3306, change it to 3333 and delete // didnt helped Quote Link to comment Share on other sites More sharing options...
BugsLIFE Posted August 16, 2013 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 37 Reputation: 4 Joined: 06/07/13 Last Seen: April 27, 2022 Author Share Posted August 16, 2013 bump? i just need to know how to change sql ports in flux.. instead of default 3306 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.