danielc wrote:seems it is working now,
C:\xampp>mysql_start.bat
Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.cnf (console)
081231 12:12:49 [Warning] option 'thread_stack': unsigned value 65536 adjusted t
o 131072
081231 12:12:49 [Note] Plugin 'InnoDB' disabled by command line option
mysql\bin\mysqld: Table 'mysql.plugin' doesn't exist
081231 12:12:49 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
081231 12:12:49 [ERROR] Can't open and lock privilege tables: Table 'mysql.serve
rs' doesn't exist
081231 12:12:49 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20
. Created with MySQL 50015, now running 50130. Please use mysql_upgrade to fix t
his error.
081231 12:12:49 [ERROR] mysql.user has no `Event_priv` column at position 29
081231 12:12:49 [ERROR] Cannot open mysql.event
081231 12:12:49 [ERROR] Event Scheduler: An error occurred when initializing sys
tem tables. Disabling the Event Scheduler.
081231 12:12:49 [Note] mysql\bin\mysqld: ready for connections.
Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL
)
but:
C:\xampp\mysql\bin>mysql_upgrade.exe
Looking for 'mysql.exe' as: C:\xampp\mysql\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\xampp\mysql\bin\mysqlcheck.exe
Running 'mysqlcheck'...
C:\xampp\mysql\bin\mysqlcheck.exe: Got error: 1045: Access denied for user 'root
'@'localhost' (using password: NO) when trying to connect
FATAL ERROR: Upgrade failed
how can i provide the password with upgrade?
I have google it and found the options of using mysql_upgrade, - u [username] and - p
-p stands for using password
so it should be mysql_upgrade.exe -u root -p , if root have password,
This is the result from me:
C:\xampp\mysql\bin>mysql_upgrade.exe -u root -p
Enter password: ***********
Looking for 'mysql.exe' as: C:\xampp\mysql\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\xampp\mysql\bin\mysqlcheck.exe
Running 'mysqlcheck'...
cdcol.cds OK
font.font OK
gallery2.g2_accessmap OK
gallery2.g2_accesssubscribermap OK
gallery2.g2_albumitem OK
gallery2.g2_animationitem OK
gallery2.g2_cachemap
error : Table upgrade required. Please do "REPAIR TABLE `g2_cachemap`" to fix
it!
gallery2.g2_childentity OK
gallery2.g2_comment OK
gallery2.g2_dataitem OK
gallery2.g2_derivative OK
gallery2.g2_derivativeimage OK
gallery2.g2_derivativeprefsmap OK
gallery2.g2_descendentcountsmap OK
gallery2.g2_entity OK
gallery2.g2_exifpropertiesmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_exifpropertiesmap
`" to fix it!
gallery2.g2_externalidmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_externalidmap`" t
o fix it!
gallery2.g2_factorymap OK
gallery2.g2_failedloginsmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_failedloginsmap`"
to fix it!
gallery2.g2_filesystementity
error : Table upgrade required. Please do "REPAIR TABLE `g2_filesystementity`
" to fix it!
gallery2.g2_group
error : Table upgrade required. Please do "REPAIR TABLE `g2_group`" to fix it
!
gallery2.g2_item
error : Table upgrade required. Please do "REPAIR TABLE `g2_item`" to fix it!
gallery2.g2_itemattributesmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_itemattributesmap
`" to fix it!
gallery2.g2_lock OK
gallery2.g2_maintenancemap
error : Table upgrade required. Please do "REPAIR TABLE `g2_maintenancemap`"
to fix it!
gallery2.g2_mimetypemap
error : Table upgrade required. Please do "REPAIR TABLE `g2_mimetypemap`" to
fix it!
gallery2.g2_movieitem OK
gallery2.g2_permissionsetmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_permissionsetmap`
" to fix it!
gallery2.g2_photoitem OK
gallery2.g2_pluginmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_pluginmap`" to fi
x it!
gallery2.g2_pluginpackagemap
error : Table upgrade required. Please do "REPAIR TABLE `g2_pluginpackagemap`
" to fix it!
gallery2.g2_pluginparametermap
error : Table upgrade required. Please do "REPAIR TABLE `g2_pluginparameterma
p`" to fix it!
gallery2.g2_ratingcachemap OK
gallery2.g2_ratingmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_ratingmap`" to fi
x it!
gallery2.g2_recoverpasswordmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_recoverpasswordma
p`" to fix it!
gallery2.g2_rssmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_rssmap`" to fix i
t!
gallery2.g2_schema
error : Table upgrade required. Please do "REPAIR TABLE `g2_schema`" to fix i
t!
gallery2.g2_sequenceid OK
gallery2.g2_sequencelock OK
gallery2.g2_sessionmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_sessionmap`" to f
ix it!
gallery2.g2_tkoperatnmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_tkoperatnmap`" to
fix it!
gallery2.g2_tkoperatnmimetypemap
error : Table upgrade required. Please do "REPAIR TABLE `g2_tkoperatnmimetype
map`" to fix it!
gallery2.g2_tkoperatnparametermap
error : Table upgrade required. Please do "REPAIR TABLE `g2_tkoperatnparamete
rmap`" to fix it!
gallery2.g2_tkpropertymap OK
gallery2.g2_tkpropertymimetypemap
error : Table upgrade required. Please do "REPAIR TABLE `g2_tkpropertymimetyp
emap`" to fix it!
gallery2.g2_unknownitem OK
gallery2.g2_user
error : Table upgrade required. Please do "REPAIR TABLE `g2_user`" to fix it!
gallery2.g2_usergroupmap OK
mysql.columns_priv OK
mysql.db OK
mysql.func OK
mysql.help_category
error : Table upgrade required. Please do "REPAIR TABLE `help_category`" to f
ix it!
mysql.help_keyword
error : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" to fi
x it!
mysql.help_relation OK
mysql.help_topic
error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" to fix
it!
mysql.host OK
mysql.proc
error : Table upgrade required. Please do "REPAIR TABLE `proc`" to fix it!
mysql.procs_priv OK
mysql.tables_priv OK
mysql.time_zone
error : Table upgrade required. Please do "REPAIR TABLE `time_zone`" to fix i
t!
mysql.time_zone_leap_second
error : Table upgrade required. Please do "REPAIR TABLE `time_zone_leap_secon
d`" to fix it!
mysql.time_zone_name
error : Table upgrade required. Please do "REPAIR TABLE `time_zone_name`" to
fix it!
mysql.time_zone_transition
error : Table upgrade required. Please do "REPAIR TABLE `time_zone_transition
`" to fix it!
mysql.time_zone_transition_type
error : Table upgrade required. Please do "REPAIR TABLE `time_zone_transition
_type`" to fix it!
mysql.user OK
phpmyadmin.pma_bookmark OK
phpmyadmin.pma_column_info OK
phpmyadmin.pma_designer_coords OK
phpmyadmin.pma_history OK
phpmyadmin.pma_pdf_pages OK
phpmyadmin.pma_relation OK
phpmyadmin.pma_table_coords OK
phpmyadmin.pma_table_info OK
tutorial.user OK
webauth.user_pwd OK
Repairing tables
gallery2.g2_cachemap OK
gallery2.g2_exifpropertiesmap OK
gallery2.g2_externalidmap OK
gallery2.g2_failedloginsmap OK
gallery2.g2_filesystementity OK
gallery2.g2_group OK
gallery2.g2_item OK
gallery2.g2_itemattributesmap OK
gallery2.g2_maintenancemap OK
gallery2.g2_mimetypemap OK
gallery2.g2_permissionsetmap OK
gallery2.g2_pluginmap OK
gallery2.g2_pluginpackagemap OK
gallery2.g2_pluginparametermap OK
gallery2.g2_ratingmap OK
gallery2.g2_recoverpasswordmap OK
gallery2.g2_rssmap OK
gallery2.g2_schema OK
gallery2.g2_sessionmap OK
gallery2.g2_tkoperatnmap OK
gallery2.g2_tkoperatnmimetypemap OK
gallery2.g2_tkoperatnparametermap OK
gallery2.g2_tkpropertymimetypemap OK
gallery2.g2_user OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_topic OK
mysql.proc OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
Running 'mysql_fix_privilege_tables'...
OK