MySQL

I recently downloaded the 5_2 Uniserver, and updated phpMyAdmin to 3.2.2.1 and tried to update MySQL to 5.1.40 after reading through some of the upgrading posts on here. I thought I had it all set up right, but now everytime I go to phpMyAdmin, the Apache server crashes. Here's the error: [notice] EACCELERATOR(1632): PHP crashed on opline 5 of mysqli_fetch_array() at D:\UniServer\home\admin\www\phpMyAdmin\libraries\dbi\mysqli.dbi.lib.php:233 Any ideas?

Greetings, I am hoping to use uniformserver with my class of 23 grade 11 Computer Science students to teach them the basics of Web servers/php/mysql/apache... On their machines, the XP command prompt is disabled by Group Policy. I was hoping to use the MySQL terminal but it does not come bundled with UniformServer. Is there a way to get MySQL terminal working quickly with UniformServer? I know phpmyadmin is fabulous, but I really want my students to get an understanding of things from the command prompt...

Hi there, I used to have Xcart working with an older version of Uniform server (i forget which older version now...sorry) The install of Xcart goes fine until a point where its creating tables. It always bombs out at the same table. I was wondering has anyone got the latest builds working with Xcart 4.2.2? Im not sure what other information is needed other than in running windows 7 64 bit and have tried it on that and on a virtual XP machine as well.

These problems originally occurred using Uniform Server 4.3. I updated to version 5.1 and the problems still existed. I created a procedure in MySQL to retrieve data from a table. When I called the procedure, I got the following error message; Error Code : 1436 Thread stack overrun: 6436 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack. I also created a function to multiply two numbers. When used, I received the following message; Error Code : 1436 Thread stack overrun: 9124 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack. …

I've searched the SQL forums and looked at the other topics regarding this issue, I've attemped those fixes, but have had no luck. The error is I'm gonna say "Bill" is the username. I'm trying to get SQL 5.1.36 installed. Anybody know of another work around? This is for UniServer 4.3 The only change I've done to the sever is upgraded PHP to 5.3.0 Thanks

I have an Error installing core module for gallery2. This is the download from gallery2 website (http://gallery.menalto.com/downloads). This is the first step toward installing the Drupal module for inserting gallery2 (http://drupal.org/project/gallery) The response from gallery2 forum: "It looks like your mySql database is not set up properly. You need to enable the 'InnoDB' feature in the database that you are tyring to create." In phpMyAdmin; MyISAM is default and don’t see how to change to InnoDB also "InnoDB has been disabled for this MySQL server." Question: 1).How do I enable InnoDB engine? 2). Is there a way to use gallery2 with MyISAM? Thanks fo…

I am experiencing a very slow response with phpmyadmin. Browse a smal db of 2 tables is taking ages and often timeout. All other responses on the server are fine. Is there a utility to run to optimise mysql performance.

I am using Uniformserver 4 and I am trying to set up an ODBC connection so I can import the data to Excel. I have downloaded and installed the Mysql ODBC 5.1 driver but when I try to add the connection it give me an error "Connection Failed: [HY000][MySQL][ODBC 5.1 Driver]Host Games' is not allowed to connect to this MySQL server". I have an older version ov excel running on the computer running uniformserver 4 but I have MS Office Home & Student edition on my game machine. How can fix this? Thanks.

hi i am trying to connect to mysql database and am getting the following error from mysql. MySQL said: #1045 - Access denied for user 'ODBC'@'localhost' (using password: YES) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server. i am running the uniform server on a windows XP platform and am unable to acces the DB. the strange thing is that the system is trying to acces the DB using a ODBC user name that i did not configure. any thoughts? thanks a lo…

I've been using Uniform Server off and on for a number of months quite successfully. Previously I had Mysql Administrator installed and it worked normally. I have recently been forced to wipe and reinstall windows. Since windows has been re-installed I tried to re-install Mysql Administrator but this time get an error msg when launched. Error msg reads: "Either the server service or configuration file could not be found. Startup variables and service section are therefore disable." I'm running XP sp3. The service pack was not installed when it worked previously so I don't know if that could be causing the problem. My dad also uses Uniform Server on a Windows 2000 sys…

I have downloaded and unzipped Uniform Server 3.5 I have changed nothing. When I run Server_Start.bat everything appears to work perfectly with the exception of MySQL. If I click on phpMyAdmin from the admin panel, I get this: If I attempt to change the MySQL password via the admin panel, I get this: I cannot login via command line with "W:\usr\local\mysql\bin\mysql -uroot -proot" because I get the following: I'm at a loss as to how I can get MySQL working. I have no competing installation of MySQL on my box. This is a completely fresh copy of Uniform Server, out of the box. my 'mysql_password' file says 'root' in it. It appears that's what the system…

Hi, First post, this one. I know, a lot of people do first-posts asking questions and never return to read the answer or bother thanking people for their efforts. They suck, and I am not one of them, worry not. So if anyone has any multi-paragraph nuggets of awesome to share with me, your efforts really will be appreciated. Anyway, I'm writing this because the forum on my website is ill, and I cannot work out what is wrong with it. Here's the link to an affected page - http://www.yourlost.co.uk/forum/index.php?...amp;msg=10772.1 Now, I'm not sure whether this will load for you quickly the first time and quickly each time thereafter, or will load after an epic-lon…

Hi. The first time I ran the Uniform Server, I changed my mysql password, and now whenever I do something to change the password or go into the account via PHPMyAdmin, it gives me this: I have read the other post btw, but it does not really help me. Happens with both my desktop and laptop. I really need some help.

never mind i got it.

Hi I was using uniform server with no problem until last night that i get this error; what's the problem?

Hello, I hope someone can help here. I am new to PHP and MySQL. I have recently installed PHP, Apache, MySQL successfully it seems. I am running Uniform Server to run them all which seems to be fine but when I open phpMyAdmin it gets a little hazey here. This is what I am getting: phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: YES) Invalid hostname for server 2. Please …

I find it difficult to locate what I need on the Uniform Server Web site. Are there any manuals on this site? I'm getting a syntax error and I don't know where on this site to find documentation/manual to solve the problem. The error says: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'platform varchar(10)' The code I'm typing in at the mysql prompt is: create table languages ( language_id int unsigned not null auto_increment primary key, name varchar(10), platform varchar(10) ); thanks.

I'm following a tutorial to learn PHP. The tutorial is assuming individual installation of PHP, MySQL, and Apache.--not The Uniform Server. The tutorial has an exercise which requires access to MySQL. I'm supposed to type a statement at the mysql> prompt. I can't figure out how to get to the mysql prompt. I don't see any MySQL files in the Uniform Server folder. I used the UniServer admin panel to check if MySQL is running. It is. That's all I can figure out. Any help/direction will be appreciated. Thanks.

If you like exploring and playing! Have you considered upgrading to MySQL 5.0.51a then take a look at this page: http://center.uniformserver.com/us_35_oily..._upgrade_2.html I confess it’s not fully tested but worth a bash. All the best Ric

Hello, I have a problem. When I started to instal UFS, it appear me a short message: "The procedure entry point mysql_set_caracter_set could not be located in the dynamic link library LIBMYSQL.dll". What does it mean ? NOTE: I read the last topics and I delete LIBMYSQL.dll. But the results is that the UFS not working properly yet. What's happened ? Please help me. Thank you.

I would like to telnet into mysql to upload a large database file. But I can't seem to connect to my localhost server. I've searched on the board and only found a couple hits on this but doesn't actually touch on what my problem is. Any suggestions? Thanks!

i exported my database with phpAdmin export function, and it generated a .SQL file, now i want to upload it. What do i need to do in order to access this. Would my code pick this up???

i am developing a website in php with a MySQL database. I know that the php files are in the WWW directory, but where the hell are the mySQL files so i can upload them to my server,lol?

Hi! I'd like to remove MySQL from Uniform Server package. I won't really use it and I prefer remove it from the server. How can I remove it? Is it any version without MySQL? Thank You!!

I'm using uniserver for my local test server for my ecommerce software...xcart... Everything was working fine till yesterday while trying to import into the DB I get the following error: INVALID SQL: 10001 : The size of the data package being transmitted is greater than maximum allowed by the server SQL QUERY FAILURE:UPDATE xcart_sessions_data SET data= I truncated all the jibber jabber out of it... My php settings on uniserver are: Max memory amount 256M post_max_size = 32M upload_max_filesize = 32M max_allowed_packet = 32M The file that I am trying to import is only 900KB...so I am confused as to where the problem lies...everyone tells me to put this line i…