MySQL

Hi, I just set up a small DB to store some information, and i was hoping to use Dreamweaver to quickly build pages to display it. However, i'm not sure what settings to put into this prompt, specifically the MySQL Server field. Is it asking for an address? a name? ???? When i enter localhost as the server i get the following error: Can anyone help?

Dear All My host only offers mysql 4.1, i had problems when i tried to export my mysql 5, i had to change every autoincrement field. Now i want to import my online mysql 4.1 to my uniform server that runs mysql 5 i get errors every time.. what should i do ? should i run 4.1 on my mashin to solve that problem ?

Me and olajideolaolorun spent an entire night trying to figure this out. We could not figure out how to get around this. Basically MySQL will not start up when I ask for it to start running. We tried MANY things and nothing worked. We tried so many things, its easier just to post the conversation we had. sachit: haha, alright... here's a quick story first to help you understand sachit: my office hired a guy to do their database... guy was an amateur (hated codign and thought it was hard)... so he made it in filemaker pro sachit: i hated it.... so i said i'd help design it again in mysql sachit: so, i found WAMP and found your Uni Server and wanted to install it on my U…

Perdon, pero mi inglés es malísimo. Por eso agradeceria una contestación es Spanish. He instalado el UniforServer, y el Apache me funciona perfectamente. Sin embargo, no consigo conectar con la Base de Datos. Realizo la conexión así: <? $sql_host="localhost"; // Host $sql_usuario="root"; // Usuario de Mysql, según la tabla "user" de mysql $sql_pass="67457e226a15bd"; // contraseña de Mysql, según la tabla "user" de mysql $sql_db="datos"; // Base de datos que se usará. $sql_tabla="direcciones"; // Nombre de la tabla que contendrá los datos de los usuarios $db_conexion= mysql_connect("$sql_host", "$sql_usuario", "$sql_pass") or die("No se pudo conectar a …

Hi, While reinstalling uniform server, I renamed my original directory from /userve to /userve.old In mysql/data was what I thought my phpbb and zencart database as there were folders with those names in there. When I reinstall a fresh copy of uniform server to /userve, my old databases are not in userve/diskw/usr/local/mysql/data but when I use phpmyadmin, it 'seems' to access my old databases in /userve.old/diskw/usr/local/mysql/data/zencart Is this correct behaviour? Can I copy across my old database from userve.old/diskw/usr/local/mysql/data into the /userve/diskw/usr/local/mysql/data ? Or leave them alone Can I delete userve.old/mysql/data?? Thanks Al…

Could not open required defaults file: my-small.cnf Fatal error in defaults handling. Program aborted Press any key to continue . . . This is what i get when i try to launch mysqlstart.bat I have modified the my-small.cnf so as to have InnoDB support. And here's what it looks like: # The Uniform Servers MySql Config File. # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server …

I have Uniserver 3.1, and now i need more features from MySQL 4.1 (3.1 version use MySQL 4.0) how to upgrade mysql Version at my Uniform Server to 4.1?

I put my db in libreria usr\local\mysql \ and it does not work. In which libreria I put my data base?

I discovered an error when I updated the phpMyAdmin version. This problem is also found in the MySql log files. It's a warning to update of the mysql user data files. I have made an update to the files. You will need to replace all files in the zip file with the new files. Here is the zip file Please try it, and report any other problems here. (I know developer has a lot of other things to do, but if this thread is more appropiate in development section please move it) Edit: the attachment does not work, and I can't understand why!!! /BK mysql.zip

Have been using Uniform server for a while - love it However, I donloaded the latest version Am trying to use php_mysqli.dll In previous versions I have added this file to the php extensions directory In the php.ini file added the line: extension=php_mysqli.dll After that I was able to use mysqli This does not work in the latest version - have gone nuts trying to figure it out Does anyone have any ideas? Pls!!!

Hi all, Great product. I can't seem to get InnoDB support with Uniform Server 3.3 (I am using XP). For example, When I create a script below: CREATE TABLE prime_minister ( pm_name varchar(12) NOT NULL PRIMARY KEY, birth_yr smallint NOT NULL, yrs_served numeric(7,2) NULL, death_age smallint, state_born varchar(3) NULL, state_rep varchar(3) NOT NULL )TYPE=InnoDB; CREATE TABLE pm_recreation ( pm_name varchar(12) NOT NULL , recreation varchar(15) NOT NULL , PRIMARY KEY(recreation,pm_name), INDEX(pm_name), CONSTRAINT pm_name_fk FOREIGN KEY (pm_name) REFERENCES prime_minister(pm_name) )TYPE=InnoDB; Uniform server DOES NOT allow…

I posted previously about thid problem. I am trying to make a Joomla release on the stick, but I am always hitting the same problem Nice Admin told me to look for previous posts concerning this issues, and I did... but without success. This is what I have done: This is my modified bat file : Name: Start Server File : Created By: The Uniform Server Development Team : Edited Last By: Olajide Olaolorun (empirex) : Comment: After start, go to apanel directly. : To Developers: Implemented %www%, and %apanel% @echo off rem use: start mysql console - to start mysql at server start and display console rem use: start mysql - to start mysql at server start rem use: start …

Hey gang, I setup Uniform server on a development machine and i plan to do all my work on a seperate machine, i have changed htaccess to allow my seperate machine access to view the web pages. I would also like to gain access to mysql remotely and use for instance Navicat or Mysql administrator but when i test the connection remotely i receive an error "Host my ip address is not allowed to connect to this Mysql server. Is there something i can change so that i can get access. Thanks!

Hi, Can anyone tell me how to set the max file size for mysql. Seems it's limited to 1M. Thanks in advance ROT

I run Uniform Server 3.3 (exe installed version), when I get to the admin page, I select Run MySQL. It says MySQL was started, so I choose phpMyAdmin and I get the error: MySQL said: #2003 - The server is not responding It was working fine earlier. I havn't done anything since then . EDIT: I pressed 'Clean Server' and my files stayed intact, but phpMyAdmin is now working.

I now use 3.3 but in phpinfo it says: mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 4.1.7 How can i upgrade to 5.x ?

I have seen the other threads on this topic under version 3.2, and the solution was to upgrade to 3.3. Well, I have 3.3 installed on a USB Drive, and have run on 2 seperate machines and get the following error on both. Any ideas? » Security Alert! Possible Attack HTTP_REFERER is not localhost. but ''. To disable this warning go: /home/admin/www/cgi-bin/secure.pm

Hi! I noticed that the UniServer 3.3 has various plugins, like PHP4, etc. I could not locate MySQL plugins, though. They would be nice to have because this way local and live environments could be matched. Ulternatives are to use earlier releases of UniServer which have MySQL4 installad, but I am not sure what one would loose on the servers performance. Thanks for your advice, --doc

When I click 'Run MySQL Server', I get an error message.... .... yet I'm reaching this page from http://localhost/a/ Is this normal? I have disabled the warning as instructed, but doing so makes me a little nervous....

I was connecting fine to my database using root as the password and user. I edited the \home\admin\www\mysql_password file. Now I can not connect to my database, even if I try to change it back...

Not sure where the problem lies, so hopefully you can make sense of my post. First off, let me say that I love Uniform Server! I found it today while at work 'cause the boss really likes some of the PHP/MySQL scripts I use and wanted to make them available to the rest of the employees (we are on a non *nix server). I ran it (with PHPmyAdmin and MySQL without a hitch - piece of cake! Anyway, when I got home today, I downloaded 3.3 for myself and ran into the above mentioned problem. I commented out the warning in the appropriate file - but when I try to access phpMyadmin, I get "Server is not responding". I'm running Norton Internet Security - could that be the…

So I get on my PC after coming home and notice the mysql is not up. I try turning it on and the command window doesn't even show, so I go to do it manually and the window flashes so fast I can't see the error, I've tried to print screen it but I can;t. I re-installed the server and it's still not working. I'm pissed. help out!

sorry, I know there are already 2 related topics, I checked them, but I still need some more help (I a newby...) so, I would like to use latin2 charset (hungarian). there are no problems when I am displaying data got from MySQL, but some characters do not appear correctly in FPDF. In FPDF I am using an ISO-8859-2 (latin2) charset, I made the the font myself (built from Courier, and mapped it as in the fpdf documentation). However, characters appear correctly on the webpage, but only codes appear in the generated PDF (instead of the őű characters I got ő and ű). I dont know where the error is, because only data coming from MySQL appears incorrectly in the pdf file, sam…

Hi, I have a nicely running Mambo application on a live site. I developed it locally using the Mambo Stand Alone Server (MSAS). I want to abondone MSAS because I like the UniServer 3.3 more, because it gives better handle on things. Neither my good running MSAS nor the live installation runs without this error on the UniServer: DB function failed with error number 1054 Unknown column 'c.access' in 'on clause' SQL=SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM mos_content AS c, mos_categories AS cc, mos_sections AS s LEFT JOIN mos_groups AS g ON g.id = c.access LEFT JOIN mos_users AS u…

Hi!, I eut still entered a valid username/password but still cannot login. I use one of server users name/pass. Is is not what meant? Thanks, --doc