Quote:
SQL query:
--
-- Database: `********_****`
--
CREATE DATABASE `serverredirect` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL said:
#1044 - Access denied for user '********'@'localhost' to database 'serverredirect'
|
To fix this issue, create the database first. After the database has been created navigate to it in phpmyadmin. Open up mysql_new_install.sql with notepad and delete the following lines:
Code:
--
-- Database: `serverredirect`
--
--CREATE DATABASE `serverredirect` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
--USE `serverredirect`;
-- --------------------------------------------------------
You should be left with:
Code:
--
-- Table structure for table `server`
--
CREATE TABLE IF NOT EXISTS `server` (
`id` int(11) NOT NULL auto_increment,
`address` varchar(50) NOT NULL default '127.0.0.1',
`groupnumber` int(11) NOT NULL default '1',
`last_update` datetime NOT NULL,
`display_name` varchar(100) NOT NULL default '[new server]',
`offline_name` varchar(100) NOT NULL default '[offline]',
`maxplayers` int(11) NOT NULL default '0',
`currplayers` int(11) NOT NULL default '0',
`map` varchar(70) NOT NULL default '[no map]',
PRIMARY KEY (`id`),
KEY `groupnumber` (`groupnumber`),
KEY `last_update` (`last_update`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `server`
--
INSERT INTO `server` (`id`, `address`, `groupnumber`, `last_update`, `display_name`, `offline_name`, `maxplayers`, `currplayers`, `map`) VALUES
(1, '127.0.0.1:27015', 1, '2008-12-31 00:00:00', 'Example Server | {MAP} | {CURR}/{MAX}', 'Example Server | OFFLINE', 0, 0, '[no map]');
Import it.