Database
All content about Database — 6 results.
Database
Install MySQL and phpMyAdmin for the MU Online server website
Complete guide to installing MySQL and phpMyAdmin for a MU Online server website: the critical difference between MySQL (for the website) and SQL Server (for the game), when to install MySQL separately vs using XAMPP or AppServ, the full MySQL Community Server installation walkthrough (7 steps including the authentication method choice for PHP compatibility), how to install phpMyAdmin manually and configure config.inc.php, how to create the website database and import the web system's SQL file, how to create a dedicated MySQL user (never use root in the site config), common MySQL connection errors and how to fix them, and security best practices (no port 3306 exposed, strong root password, dedicated user).
How to set up SQL Server for MU Online
Complete guide to configuring SQL Server for a MU Online server: restoring the MuServer databases (MuOnline, EventMU, RankingMU, LogServer), the correct collation that prevents character encoding issues, creating a dedicated SQL login with the right permissions, configuring ODBC Data Source Names (DSNs) so MuServer components can reach the database, the mandatory connection test before starting any game server component, reading and interpreting connection errors, enabling automatic startup so the database starts with Windows, and the three most common SQL configuration mistakes that cause Connect Fail.
How to install SQL Server 2008 R2 for MU Online
Complete guide to installing SQL Server 2008 R2 for a MU Online server: why it's the most compatible version for Season 6 distributions, the difference between the Express, Standard, and Enterprise editions, the full installation walkthrough (7 steps with the critical Mixed Mode authentication step explained), how to install and use SSMS (SQL Server Management Studio), enabling the TCP/IP protocol and setting port 1433 in SQL Server Configuration Manager, configuring the SQL Server Browser service, creating the SQL Server user that MuServer will connect with, the most common installation errors and fixes, and verifying the installation is working correctly before configuring the MuServer.
Install SQL Server 2014/2017/2019 for MU Online
Complete guide to installing modern SQL Server versions (2014, 2017, 2019) for MU Online: when modern SQL is the right choice vs SQL Server 2008 R2, the Express vs Developer vs Standard edition comparison, the full installation walkthrough with the critical Mixed Mode authentication step, why SSMS is now a separate download and how to get it, enabling TCP/IP in Configuration Manager, database compatibility levels for running classic S6 distributions on modern SQL (setting level 100 for SQL 2008 compatibility), creating the MuServer login user with T-SQL, and the most common compatibility problems when migrating a classic distribution from SQL 2008 to SQL 2019.
How to install SQL Server 2000 for a classic MU Online server
Complete guide to installing SQL Server 2000 for old MU Online distributions (versions 0.97 and 0.99): when SQL Server 2000 is the right choice vs SQL Server 2008 R2, why SQL 2000 has compatibility issues on modern Windows and the recommended virtual machine approach, step-by-step installation on Windows XP/2003 (in VMware or VirtualBox), why Service Pack 4 (SP4) is absolutely mandatory, how to configure Mixed Mode authentication for MuServer connectivity, the Enterprise Manager and Query Analyzer tools included with SQL 2000, how to import the classic MU databases (.bak files), what to do when the installation fails on modern Windows, and the migration path from SQL 2000 to SQL 2008 R2 if your distribution supports it.
How to Create Real-Time Ranking Website for MU Server
Build a live-updating ranking portal for MU Online S6 servers — covering all 6 classes, guild boards, and database architecture.