Linux » MySQL » management

Changes for document management

Last modified by root on 14-43-2013
From version 2.2
edited by root
on 05-17-2012
To version 3.1
edited by root
on 14-43-2013
Change comment: There is no comment for this version
Content changes
==== "Table ‘mysql.servers’ doesn’t exist" ====
~1. mysql_upgrade -u root -p
2. mysql_fix_privilege_tables ~-~-user=root\ ~-~-password=mysqlpasswordhere ~-~-verbose
3.mysql> CREATE TABLE `servers` (
`Server_name` char(64) NOT NULL,
`Host` char(64) NOT NULL,
`Db` char(64) NOT NULL,
`Username` char(64) NOT NULL,
`Password` char(64) NOT NULL,
`Port` int(4) DEFAULT NULL,
`Socket` char(64) DEFAULT NULL,
`Wrapper` char(64) NOT NULL,
`Owner` char(64) NOT NULL,
PRIMARY KEY (`Server_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COMMENT=’MySQL Foreign Servers table’;

Spaces

 | Arduino | Blog | Dashboard | Java | Linux | Main | MulltiWii | NEAX2000 | Radio | VOIP


This wiki is licensed under a Creative Commons 2.0 license
XWiki Enterprise 3.5 - Documentation