MySQL

Please update MySQL to version 5.7 as starting from this version MySQL added the important support to JSON.

Hello, i'm trying to change the base password of the MySql and i'm not making it, i try using the UI in normal & safe mode, the last one seems to work to change the port in Apache last time i update my UniServZ, but this time and in this case, nothing, i have installed the last version, downloaded (21/02/2016) of UniServZ any suggestions in how to fix this? Please not than i already try to reset the root user & password using the button on the UI, i have windows 10 64x Suggestions, questions or comments to improve this post and/or find it a solution would be much apreciated Thanks in advance

if in my.ini change [mysqld] bind-address = 127.0.0.1 skip-name-resolve to [mysqld] bind-address = 10.10.10.10 skip-name-resolve or some one other don't work buttons "Stop MySQL" and "MySQL Console"

Hello, I am running Coral 8.9.0 with the following my.in cfg : [mysqld] # bind-address=0.0.0.0 port=3308 server-id = 1 pid-file=mysql.pid default-storage-engine=MYISAM # skip-external-locking the problem is mysqld1.exe still listen on port 3308 with this addrs: 127.0.0.1 not on 0.0.0.0 ,hence I cant access mysql from remote PC. How to fix this problem How to make mysqld1.exe use this addrs : 0.0.0.0 Thanks

Hello there, Running Windows 7 x64 with UniServer latest version (11_8_0_ZeroXI), and update to MySQL 5.6.26. If I restart the computer without shutting down MySQL from UniController first, MySQL is not shut down gracefully (I assume this because I see no traces of shutting down in the log). Upon reboot, and when I will try to start the MySQL server, it will not start and I will get a log like that: Is this a known issue? is there a fix to this? Thanks!

Hi, I'm interested in compressing some myisam tables. There's supposed to be a utility shipped with mysql called myisamchk. I presume it should be in the UniServerZ\core\mysql\bin folder. Does anyone know if such utilities exist somewhere? I couldn't find them to download separately either. Looks like they are supposed to be packaged with mysql... Thanks Dean

Support Forum, I just started using Uniform Server on a Windows XP Pro system to be used for software testing. I defined a web site and Apache is working great. The problem that I'm having is that I cannot connect the the MySQL database from any other desktop on the network. I have written a very simple application that just tries to connect the the MySQL server based on the location, databaseName, user and password. When I run it on the same desktop that Uniform Server is installed it works great, however when I run it from a different Windows 7 desktop on the network the connection fails with the following error message. "Can't connect to MySQL server on '192.1…

Good Day I used a program than allows me to sync all the www folder without the need of move it UniformZ to another folder, and it works charmly, i wonder... Is it possible to sync a folder to make the database all at once sync too?, what file(s)/folder will be needed to make this sync all just fine? or there is another way to do it? Thanks in advance -Obsdark-

Hi I know you can make it to not show the window to put in commands but how can i make it not show any cmd windows. I'v tried changing the run bat but it will still show the 'server has been started window'. thanks

Hi there, I need some help, please... I have "installed" the Uniform Server Zero XI 11.3.3 on my C drive and add my joomla site within www folder. However I wasn't even able to install joomla for I got the message: Error displaying the error page: Application Instantiation Error: Could not connect to MySQL. I have created a new mysql database and imported the site's database into it. Also I have modified the paths for logs and tmp folders, the database name and user in configuration.php. Nothing else happened. Please advise. Thank you. The MySQL error log is as follows: 141021 12:07:16 [Note] Plugin 'FEDERATED' is disabled. 141021 12:07:16 InnoDB: The InnoDB memory …

I've been running UniServer Zero for quite a while without problems. I run it from an external hard drive. I am running version UniServer Zero XI 11.0.7 with UniController XI V1.0.6. (On WinXP). Today when I started the controller, (in the same environment as usual, no changes to system since last run), I clicked 'Start Apache' as usual without problem. Then when I clicked 'Start MySQL', I got Warning: Failed to start MySQL I looked in mysql.err error log and found: 140917 13:06:38 [Note] Plugin 'FEDERATED' is disabled. 140917 13:06:38 InnoDB: The InnoDB memory heap is disabled 140917 13:06:38 InnoDB: Mutexes and rw_locks use Windows interlocked functions 140917 13:…

Hi Folks, I've had to replace my hard-drive, which had an older version of Uniserver on it, but have a copy of the entire old Uniserver folder on the new drive. I've just installed the latest version of UniserverZ on the new drive. How can I migrate the MySQL database data from the old setup into the new one? (My first thought is to run the old version of Uniserver and export the various databases and then import them into the new version of MySQL under UniserverZ - does this make sense, or is there a better way?) Thanks very much. Gary

Hi, I've just updated my local development copy of Uniform Server from an outdated Coral release to the new Zero XI 11.1.7 and am enjoying the more modular layout. I've had no trouble getting PHP (5.3 -> 5.6) and Apache configured for my needs, but I don't seem to be able to swap the MySQL data directory on either 5.5 or 5.6? It just ignores my datadir directive in the my.ini file (using the default data directory works fine). It does take note of other commands such as moving the log files, but if the error log is loaded from the control panel (MySQL -> Error Log) it always loads the log from the default data directory and not the one I have specified. If this …

I have tried searching the forum archives and the web for instructions on upgrading Uniserver's MySQL version, but cannot find any. Can someone provide me instructions? I am currently running Uniserver 8.8.1 and want to upgrade the MySQL from 5.5.30 to 5.6.13. I have tried downloading a ZIP of MySQL 5.6.13 and loosely following the directions on http://wiki.uniformserver.com/index.php/Oily_Rag_1:_MySQL_upgrade_5.0.41_to_5.0.51b, but MySQL would not start after the changes. Or is this the point of Uniform Server Series Zero...?

Just discover UniServer but I have installed custom MySQL instance on the server thus UniServer MySQL service refuse to start (occupied port). I wonder if UniServer can work with custom MySQL instance, is it possible? Did not find it in documentation. Thanks, L.

I was knocking my head into a wall trying to get the SQL root password changed, and I came across several threads on various pages of the forums here - all instructing me on what to do, which files to change, etc. I'm running 8.9.2, but no matter which methods I tried, I couldn't get it working correctly. I tried a side install using XAMPP on another system and it seemed to be fine, but I noticed that the password I generated for the SQL install was noticably shorter than the one I used for Uniform Server. I can't seem to find anything on your documentation that states this, but for those of you out there using password managers like Lastpass and KeePass, be sure y…

Using XP Pro I have PDO working with this version: ---------------------------- The Uniform Server 8.4.0 Apache 2.4.1 MySQL 5.5.21-community PHP 5.4.0 phpMyAdmin 3.4.10.1 eAccelerator 1.0-svn427 APC 3.1.7 UniController ---------------------------- tried updating to: ---------------------------- The Uniform Server 8.4.0 Apache 2.4.3 VC10 - OpenSSl 0.9.8x MySQL 5.5.29-community PHP 5.4.11 phpMyAdmin 3.5.5 eAccelerator 1.0-git42067ac7e2 APC 3.1.14 Xdebug 2.2.1 UniController ---------------------------- now with test connect script I'm getting: ---------------------------- Server port: 3306 Connecting to mysql Database... Connected successfully Connecting …

Goodmorning! I'm fairly new to creating servers and I just got to know Uniform Server. However when I boot 'Start_as_program.exe' I should get a window saying that I have to change my password. In my case it gives an Error straight away, this one; An error has occurred in the script page. Line: 250 Char: 2 Error: Input past end of file Code: 0 URL: file:///C:/UniServer/uni_con/includes/core_functions_inc.vbs Do you want to continue running scripts on this page? Yes/No. (I didn't change a thing in that core_functions_inc.vbs) I checked line 250, maybe theres something unusual here? Line 245-260 Function us_port_in_use_ap(port) Dim temp_file, FS,sInput temp_file = …

Gentlemen, ladies; How do I get Innodb to work? #skip-innodb has no effect. Is it possible that this version of mysql was compiled without innodb support? To replicate the issue: 1. start myqsl console 2. type myqsl -uroot -proot 3. then on the mysql prompt, type show variable like 'have_innodb'; [EDIT] Sorry guys, its not a problem with Uniform Server 8.8.2. It turns out that the following two settings in the MySQL my.ini file automatically disables innoDB: 1. innodb_log_file_size with a value greater than 5M, and 2. innodb_flush_method = O_DIRECT

I am trying out the mini server 8 in preparation for a project It seems to start fine but when I go to http://localhost:8088/phpminiadmin.php I get the following error Cannot connect to the database because: Can't connect to MySQL server on 'localhost' (10061) what should I do?? I am on windows 7 64x thanks, Megan

Using XP Pro I have PDO working with this version: ---------------------------- The Uniform Server 8.4.0 Apache 2.4.1 MySQL 5.5.21-community PHP 5.4.0 phpMyAdmin 3.4.10.1 eAccelerator 1.0-svn427 APC 3.1.7 UniController ---------------------------- tried updating to: ---------------------------- The Uniform Server 8.4.0 Apache 2.4.3 VC10 - OpenSSl 0.9.8x MySQL 5.5.29-community PHP 5.4.11 phpMyAdmin 3.5.5 eAccelerator 1.0-git42067ac7e2 APC 3.1.14 Xdebug 2.2.1 UniController ---------------------------- now with test connect script I'm getting: ---------------------------- Server port: 3306 Connecting to mysql Database... Connected successfully Connecting …

Hello First, sorry for my English. I use nano 5.6.15 for years in production environment, on an intranet. A server without a display. And I use Toad, HeidiSQL or Mysql_WorkBench from my desk (for me, better than phpmyadmin). But if I upgrade to Coral 8.6, 8.7 ..., phpmyadmin does work, but I can`t connect from Toad, Heidi or WorkBench. (After unzipping the package, just change the key and authorize in firewall). What is different about the new versions? Any idea? Thank you.

Hello. I am asking your help because these two errors are killing me. 1º - When I try to change the password of mysql in adm panel I get the following error: 2 - When I try to connect to phpMyAdmin I get the following error: If anyone knows the solution please tell me.

Hello, I am using Uniform Server 5-6-13. I am trying to use mysqli, but when I use the mysqli_connect command, my php web page does not render (blank page). It renders fine with mysql_connect. I looked in php.ini and my extension appears to be good: extension=php_mysqli.dll with no semi-colon before it. I ran my connect page (using mysql_connect) and this code: $text = var_dump(function_exists('mysqli_connect')); echo $text; it printed to the page "bool(true)", which I understand means that mysqli does exist. I must be missing a setting somewhere. I hope you know where... Thanks! -Steve

Hi there,how do I run mysql from the command line console?