phpMyAdmin

Hello everyone. I am new here and need some guidance. I am running the latest version of Uniserver Zero as I installed it last week. I am using phpmysqladmin's UI to create my tables within my database and also to add the records within them. I have a table called 'sports_league' that contains seven records. Its primary key is 'Sports_League_ID'. I also have another table called 'past_league_results' that has it's primary key as 'Past_League_Results_ID" as well as an index field called 'Sports_League_ID" with a foreign key called 'FK_sports_league' that connects the 'Sports_League_ID' to the 'Sports_League_ID' to the Sports_League' table with the 'Choose c…

In order to update phpMyAdmin 4.9.x or phpMyAdmin 5.1.x to the latest version available, simply follow these steps: Download and extract phpMyAdmin 4.9.x or phpMyAdmin 5.1.x from this link: https://www.phpmyadmin.net/downloads/ copy «UniServerZ\home\us_opt1\config.inc.php» and «UniServerZ\home\us_opt1\us_opt.ini» to «phpMyAdmin-x.x.x-all-languages\» delete (or backup) the files in the «UniServerZ\home\us_opt1\» folder and replace them with the ones from «phpMyAdmin-x.x.x-all-languages\» Hope this helps!

Hello, brand new installation of UniserverZ XV. I am trying to create a new user and grant all privileges, but am getting an error: SQL query: Copy Edit Edit GRANT ALL PRIVILEGES ON *.* TO 'sclord'@'localhost'; MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: YES) I tried without a MySQL password, with my own password, by restoring original password. I tried the console and password worked correctly - even by issuing the command from within the console I get the same error. Any help appreciated!

Where can i find language files for phpmyadmin? regards, Jeen

I setup Uniformserver as a test site at home for a phpbb3 message board, try all my mods here if they work upload to the online server. When using phpMyadmin to restore a 30 meg database it never completes and times out or I think it does the right frame of the screen goes all white or blank then when you refresh the screen only part of the tables are restored. When the restore is running very little CPU or memory is being used. Tried to use Bigdump it never completes either just stops on a page that says "Processing file: backup" the list the file name its processing. Cant understand why out of the box the tools for processing databases never seem to work and c…

I am an occasional player with Uni-Sever and I have just installed Orion 8.5.1 planning to import some old DBs from an old UniServer configuration. I found that when Importing or Exporting phpMyAdmin gives a warning and points to C:\...\UniServeretc\phpmyadmin/: I think there should be a '\' between UniServer and etc. I don't know if this is a long standing problem but I don't remember the error message in Orion 7. As a quick fix I created the directory and the SQL installed fine. The question is how do I correct the directory name for the future? I don't want a weirdly named directory floating around outside my sever directory structure. There must be a config …

Hi, iam newbie how to set uniserver so that it can be accessed via odbc on another computer?

These errors are probably due to the fact that UniController was not closed properly before exiting the program and MySQL left behind some fail-safe "trackers" that should recover the status of MySQL when a new connection is established but this does not work in a WAMP environment. Before switch off Apache and MySQL from UniController, then close UniController.exe The solution is to delete in \core\mysql\data the files (make a backup copy of the files before deleting them) ib_logfile0 ib_logfile1 auto.cnf *.err *.pid As this issue happend to me very very frequently despite carefully closing UniController interface I wrote a simple .BAT file that does…

I'm having issues trying to connect to MySQL using phpMyAdmin, this is the error: I search on google and i can't find the files than requeired to be modify according to the answers there writed. i also, have this other problem too: http://superuser.com/questions/1049057/failed-to-change-password-to-mysql-uniform-server i must say than, i try to fix that other problem changing versions, but it just continue to happend, i think both problems are connected, but i don't know exactly how, and i don't know how to fix them either. Any help, comment, request for clarification and/or suggestion than improve the question would be much apreciated too. Thanks in advance

I have Uniform Server Zero XIII 13.3.2 running on my Desktop (C:), long enough to have completely forgotten if and what and how I set it up at start. It is the working environment for a TNG genealogy site. I regularly copy the database to my online webbased site. Works fine. I have bought a laptop (and a NAS too) now, in order to be able to work in the much cooler living room during the ever warmer summers.. Now I have copied the whole folder with the server and all of the webite to the root of a network drive, with Z: as the assigned drive letter. Since Uniform Server is portable, I expected it to run automagically. But it doesn't. Killed the first instance, rebooted…

I am writing this post just to report phpMyAdmin ZeroXIII versions fail to import ZIP archives. Message: "Fatal error: Out of memory (allocated 19..." My solution was to unpack the zip file, pack it again in GZIP format and finally import it in phpMyAdmin.

Version 13.1 now, and this error without giving a solution. And no one here utters. http://forum.uniformserver.com/index.php?showtopic=3185 http://forum.uniformserver.com/index.php?showtopic=3197 http://forum.uniformserver.com/index.php?showtopic=3188 Project managers would be so kind to give us a solution. Thank you!

Hello, I've just installed Uniserver 12_4_2_ZeroXII.exe. Everything looks okay and I'm able to test several php pages. However when I click on the phpMyAdmin button in the Uniserver controller, when the web page opens it throws the error I pasted below. I've researched and I've found that changing the $cfg['Lang'] = 'es_ES'; in config.default.php "or similar" to $cfg['Lang'] = 'en_US' fixes the issue, however I see no config.default.php under the Uniserver installation. I've searched in all subfolders. Does anyone know how to solve this issue? Your help is much appreaciated. Thanks, Martin Errorconsulta SQL: Editar SET lc_messages = 'es_ES';MySQL ha dicho: #1…

I have a website working (a phpBB3 forum) on one computer under UniForm Server - complete with it's working mySQL database. I want to have exactly the same setup on a second computer. Is there a way that I can just copy ALL of the files needed, from one computer to the other, in particular without having to re-import the large mySQL database?

As the title says, this just started happening on 11.6.1 this morning. It was working fine last night. Shut down both servers and closed UniController. Started this morning and went to add a new db and got the error in the screenshot. In addition, this same thing started happening on 11.6.0 about a week ago. Tried a few things but no joy. Oh well, 11.6.1 is out so just use that. But then I tried on another computer with 11.6.0 and now THAT one is throwing the same error! There is something else afoot here These were all installs that had been working perfectly. Just plain old WP sites getting set up; no fancy stuff, just basic sites. I thought it was just limit…

Hey pls I've just installed windows 8.1, and then i set my uniform server that i was using on vista normaly, and then when i tried to phpmyadmin got this: ForbiddenYou don't have permission to access /us_opt1/index.php on this server. Someone pls help! Thx!

hello when i click on phpmyadmin i get a script error an error has occurred in the script of this page line 926 could not complete the operation due to error 800a01ad code 0 url: file:///D:/UniServer/uni_con/uni_con_program.hta and no page is open

Hello and good morning, I was hopping if someone here could help me on access phpmyadmin from another pc in the same network. My friends and i are working together on a project and the mysql database is in my computer. Sometimes they one to change settings on the db but when they try to access my phpmyadmin they got an "Access Forbidden ". I've tried to change the .htaccess file to "allow from all" but didn't work. Can someone help me please??

I use the designer option in phpmyadmin to see the relationships between tables. I have checked the config.inc.php file and the code is correct. I can see the tables in phpmyadmin but on opening I get these errors. "The phpMyAdmin configuration storage has been deactivated. To find out why click here." and "The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here." Clicking anywhere to browse data results in the attached file output. Any ideas? My system is Windows 8.1 Pro preview Build 9431 if that helps.

I'm using Coral 8.5.2. I accidentally deleted the 'root' MySQL account from PHPmyAdmin and now I get the error: #1045 - Access denied for user 'root'@'localhost' (using password: YES) I tried every solution I read about but I still can't access PHPmyAdmin. This I what I've tried so far: 1. Restore MySQL password via Coral interface: Server configuration -> MySQL -> Restore password 2. Change MySQL password to 'root' via Coral interface: Server configuration -> MySQL -> Change password 3. Edit PHPMyAdim config.inc.php which now is as follows: $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password…

Or create an alternative distribution with it. Advantages: - Support for more databases (including Sqlite!) - Light weight (smaller in size, single file, zero configuration) - Faster interface This will effectively cut down the size of Uniform Server while gaining more functionality! http://www.adminer.org/

Just noticed this today as I have not done an import to a remote hosting account site from a local US since 8.8.2. Did some testing and this occurs with US 8.8.4 and higher. US 8.8.3 still works as expected. Issue: - getting access denied error when attempting to import a US exported SQL file into the remote host phpMyAdmin. - always had worked "as expected" up until the above-noted change; that is, export the local db, create a new db on the host and import the db using the host's phpMyAdmin. Going through the change logs, I notice that phpMyAdmin has been updated along the way. 4.0.0 works (US 8.8.3) but 4.0.2 and up generate this error. How / where can whatev…

Using UniServer Zero 10.0.1, and in \UniServerZ\home\us_phpmyadmin\config.inc.php is the following :- $cfg['UploadDir'] = "$root\\etc\\phpmyadmin"; // Directory for uploaded files $cfg['SaveDir'] = "$root\\etc\\phpmyadmin"; // Directory where phpMyAdmin can save exported data $cfg['docSQLDir'] = "$root\\etc"; // Directory for docSQL imports, From memory that is the correct paths for normal Uniform Server, but is incorrect for the Zero version and should probably be :- $cfg['UploadDir'] = "$root\\home\\us_phpmyadmin"; // Directory for uploaded files $cfg['SaveDir'] = "$root\\home\\us_phpmyadmin"; // Directory where phpMyAdmin can save exported …

I am new to Uniform Server but absolutly love it. Well, I must have done something stupid along the way. I created a database and tables but was having problems. I changed the password along the way. Then, to help correct the problems, I reinstalled Uniform Server. That obviously changed the password. Now phpMyAdmin sees the database but not the tables. I did searching in the forum and tried a few things but nothing seems to have worked. Is there an easy way to get the tables to be seen by phpMyAdmin or do I have to manually recreate them? Any and all advice is appreciated. And PLEASE be kind!! LOL I will remember not to do that again! Mike

I have updated my password in phpmyadmin and in: server configuration general root www change passwords and access I can now access view www my own php programs I have root access and the valid root password. I can not access phpmyadmin #1045 - Access denied for user 'root'@'localhost' (using password: YES) I am using server program 8.7.1 How do I update the password used in accessing phpmyadmin?