MySQL

Hi there, I have looked around, and I'm trying to do it, basically I found a commented out password in the my-small file, but uncommenting and changing that doesn't work. What is the default mysql password, and how can i change it to my own? Thanks Rob

Hello, I am unable to get MySQL running. I get "Unable to connect" when I use Run MySQL Server, Stop MySQL Server, or any other Uniform Server command which uses /a-cgi/. phpMyAdmin shows the Error "MySQL said: Documentation #2003 - The server is not responding" I noticed that mysqlrun.cgi & mysqlstop.cgi are located in the W:/home/admin/CGI folder, yet the a-cgi bin references /localhost/apanel/cgi which (with the apanel alias of /home/admin/www/) would hit W:/home/admin/www/cgi directory. I've tried changing the Alias and redirects in the httpd.conf file without successfully getting mysqlrun.cgi to execute. Any help would be great. Jacob

Hello everyone. I have have great difficulties attempting to install onto a usb drive. I have read and reread until my head hurts. All I really NEED is to use it as a mysql database server with PHP. I have it copied to the usb in its own folder, and when I run server_start.vbs, it says server is working on disk w: ... and W:\user\local\php> I can do anything from there like start mysql server or access anything else. Like i Said, total newbe to this, but no to mysql and php. ANY help would be great. Thanks Rockman

Hello - I changed the Server_Start.bat so that it automatically starts MySQL when the server starts. My question is this, when I use stop.bat to stop the uniformserver, does mySQL stop also, or is there some command I need to add to the stop.bat file to stop mySQL ??? thanks, megan

Hi, I've got Uniform Server 3.2a. My browser - when I am accessing dynamics pages using Uniserver - still switches to latin1 but on the hosted server the exactly same application runs as I want, i.e. cp1250 is in use. Can you give me an advice how to overcome the problem? I am getting mad!!! I am affraid that MySQL server under Uniserver is not properly set. For each case here are some MySQL Server variables>>> Variable Session value Global value ... character set client latin1 latin1 character set connection cp1250 latin1 character set database latin1 latin1 character set results latin1 latin1 character set server latin1 latin1 character…

I've gotten this error when adding anew record to my database table. I can't interpret it so I'm passing it along to the forum. Note that I am using the link a the bottom of the "Browse' window in PhpMyAdmin. The record DOES get added, but the message (second second) says it is fatal. Nothing dies that I can detect. The messages strings are unformatted and I have forced them to fit in this window. Warning: require(./sql.php%3Flang%3Den-utf-8%26amp%3Bserver%3D1%26amp%3B collation_connection%3Dutf8_general_ci%26amp%3Bdb%3Dtwpproducts%26amp% 3Btable%3Dproducts%26amp%3Bpos%3D0%26amp%3Bsession_max_rows%3D30 %26amp%3Bdisp_direction%3Dhorizontal%26amp%3Brepeat_cells%3D100…

I've found thes errors in the mysql err log for my database and I don't know how to run the functions requested. Does this mean the something (me?) changed the "format" for passwords, or does it just mean the password itself was changed? 060108 6:49:41 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run 060108 6:49:41 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them Can someone tell me where and how to run the "fix" function specified above and how to create the missing Table 'mysql.time_zone_leap_seco…

i downloaded and installed uniserver with no problems, installed a phpBB forum over it, with a bit of help i managed to have others acces that forum. then begining with 3 days ago, while in the middle of browsing the fodum i get i error that said it can't acces the database. it was late so i just shut down and went to bed. next day it worked, and during the evenning i installed postnuke on the server, ran it and started configuring it. when i changed the theme the second time, i got a php error, that i traced back to... yes.. no mysql server running. i clicked the run mysql link in the uniserver admin panel.. it said mysql running, then i tryed to open phpmyadmin... but…

SQL=Invalid default value for 'rating_sum': - - - - - - - - - - # Table structure for table `Mambo_content_rating` CREATE TABLE `Mambo_content_rating` ( `content_id` int(11) NOT NULL default '0', `rating_sum` int(11) unsigned NOT NULL default '', `rating_count` int(11) unsigned NOT NULL default '0', `lastip` varchar(50) NOT NULL default '', PRIMARY KEY (`content_id`) ) TYPE=MyISAM = = = = = = = = = = tried with "root" and user "Mambo" into database "Mambo" did change all passwords, its preatty late (4:30am) and im doing laundry so im pretty tired atm lol tomorrow later in the evening i will try on a fresh install, diff scenarios ect.. but so far its …

Hi guys, Probably a dumb question, but is it possible to change the location of the socket for mysql_connect within the uniform server, I'd like to change it to match the path my host server uses so I dont need to keep rememberihg to modify my php code depending on weather I'm testing localy using the uniform server or uploading stuff to my host - I just put a live database out of action for 2 days (oops) because I forgot to tweak the code back having played with the php locally... Cheers Couch Potatoe

Hi all I am a newbie and have been using MySQL v4 for a few weeks and have decided to take the plunge and try out Uniform Server. Can someone please tell me why I can't use the MySQL command 'mysqldump' in Uniform Server as I want to save a backup of a database? Also I want to be able to import into Uniform Server a backuped database which I have created in MySQL v4 (I used mysqldump). I don't want to use phpMyAdmin for the above tasks. Many thanks

Hello, I recently posted this as a reply to another topic and it was suggested i start a new one. To recap i'm new to Uniform Server and thought it the best choice for my purposes. I'm new to webserving and want to set one up for the sole purpose of running a phpBB for a gaming guild. I've installed the Uniform Server software and followed the instructions. I am able to access my index.html file, as well as the test.php file i created. However i am unable to access my testmysql.php file. It was suggested that the problem might be with the code of my test file. Perhaps someone could recommend a simple test code i can make a file of for testing. I am able to access phpMya…

I am using UniServer 3.2 I am having difficulties connecting my database. I keep getting this. this is what looks like in CONFIG.PHP of phpBB. <?php $dbms = 'mysql'; // INFO CHANGED FOR PRIVACY $dbhost = 'localhost'; $dbname = 'test'; $dbuser = ''; $dbpasswd = 'root'; $table_prefix = ''; define('PHPBB_INSTALLED', true); ?> Is this right set up in CONFIG.PHP? Yes running MySQL server. Any idea how I can connect to MySQL database from phpBB via UniServer?

Using :$query = "select clientname, jobnumber, Date, id from timesheets.stanger WHERE " . $what . " LIKE '%$SearchText%'"; I then do this: MYSQL_result($result,0,0); which gives thie warning is the page displayd output: Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in W:\www\flash\test2.php on line 23 Everything works fine on this page,but when nothing is found from the 'search' then that warning message pops up. How do I turn off that warning message so it is not displayed in my webpage when there is a search that yeilds no results? I want errors to display just not a pointless warning.

Wouldn't be great if default charset and connection collation for the MySQL is utf-8? Well, for me it's a must.

I am running the standard 3.2a version of Uniform server on a Win XP 64 box with dual 2.2GHz Opterons (i.e. 4 cores), 6Gb ram and a 15k rpm scsi drive. The system is running a very large database (approx 276 million records at present) and is working pretty well. I would really like some advice on optimising the MySQL settings to improve query times as most queries now take well over an hour to run. The system doesn't appear to be making very much use of the 6GB of ram that is installed so hopefully someone can tell me how to remedy that little problem to keep more table information cached in memory. Any other optimisation tips for large databases (in terms of reco…

can someone help me figure out why my MySQL server stops all by itself? it does this quite frequently and i have to re-start it manually. It never did this before as i had run it as a seperate application, but now, using the uniform server, it shuts down by itself every day (on average), and i can't figure out what's wrong. thanks for any help! Dan

Hi, I love the server , ever since i found it my wife treath to leave me...lol...one question ? How do i add instalation info of a software such as user & pass word to Database ? just like this one http://www.lightningservers.net/cpanel-dem.../sql/index.html Does this server come with MySQL Account Maintenance? if not how do i get it to work with the Uniform server?

Hi all. Have installed Uniform Server on my Windows XP machine. All works fine. I can start the MySQL server and the default PhpMyAdmin page comes up. However, when I click on anything within this page (select database, Show MySQL info etc.), i get 'The page cannot be displayed'. Looks like there is a path set wrong. Note that the phpMyAdmin logo on the top left of the page does not appear either which also gives me to believe that it is a path problem. Any help would be much appreciated.

When creating a table with foreign key constraints, the table is created successfully; however, the constraints don't hold true. For example, when inserting values into the new table, the values inserted should match the referenced values. This is not happening. Here is an example of my statement: CREATE TABLE test (a int, b int, c int, FOREIGN KEY (a, REFERENCES test2(e,f)) Would the Uniform Server package be affecting this at all? Or, perhaps I am dong something wrong? Thanks for your help, JC

Hy, i would like to start the mySQL Server directly during Server Startup via the Start.bat file, but unfortunatly I'm a newbie and I even do not have a guess how to do this. I played with some variables in the start.bat file but i did not get the needed result. Could someone please help me solving this problem (even if it is no real problem) so long thank you

Traffic on my discussion group has increased since I installed one year ago. I have moved it to a much faster machine with 2 gig of memory. I am running on W-XP. Now I need to tweak MySQL to have a larger key buffer and allow more max connections. How do I do this? Despite what the console "help" and start.bat say, I can find no file named my.cnf or anything similar anywhere on the machine. The only thing that looks plausible is a file named my-small inside W:\usr\local\mysql\bin, but this file claims to be a speed-dialer (whatever that is). And, as far as I can tell, my phpMyAdmin 2.6.0-beta2 lets me look at the parameters but does not let me change them. Surely, t…

I have a mySQL db already how do I configure US to use this db, instead of the blank created by US. I get a MySQL said: Documentation #1045 - Access denied for user: 'root@localhost' (Using password: YES), when I try to access the db using myPHPAdmin