malum
30th of September 2010 (Thu), 08:25
I have been attempting to convert the database and all the tables to UTF-8.
My site uses a mixture of English and Chinese and the search function won't work at all without converting.
All seems to have gone well and the search is now working and the Chinese and English are displaying fine. However, I have a problem when I run a back up (using EE's back up)
It lists this at the top of the page (user name and database name have been replaced by me here)
lock ee_accessory: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_accessory_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_accessory_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_admin: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_admin_log: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_batch_cache: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_camera: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_camera_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_camera_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_category_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_category_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_commerce_template: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_counter: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_counter_index: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_counter_list: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_country_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_country_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_debug_report: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_debug_timer: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_defaults: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_error: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_exhibition: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_exhibition_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_exhibition_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_exhibition_feedback: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_exhibition_to_group: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_frame: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_ftp: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_ftp_to_microthumb: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_ftp_to_size: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_ftp_to_thumb: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_group: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_group_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_group_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_group_to_group: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_language: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_lens: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_lens_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_lens_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_light_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_light_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_link: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_link_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_link_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_link_to_group: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_location: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_login: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_message: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_microthumb_path: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_news: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_news_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_news_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_order_to_exhibition: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_order_to_group: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_order_to_indexpage: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_order_to_link: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_owner: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_owner_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_owner_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_performance: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_photo: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_photo_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_photo_comment: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_photo_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_photo_size: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_photo_to_accessory: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_photo_to_category: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_photo_to_ee_commerce_template: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_photo_to_exhibition: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_prevnext_cache: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_resizemethod: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_resultcache: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_session: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_settings: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_settings_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_settings_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_shorthand: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_size: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_size_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_size_custom_menutext_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_size_custom_menutext_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_size_defaults: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_size_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_structure_cache: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_structure_lang_cache: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_style: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_style_template: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_thumb_path: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_thumb_size: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_thumbs: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_uncookied: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_uncookied_settings: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_upload_folder: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_uploader_cache: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_user: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_viewerstyle: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_workflow: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_workflow_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_workflow_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’
Despite this list it still creates a back up and restoring from this back up also seems to work without a problem.
I don't have access to Phpmyadmin on the server right now (it's a Windows server and I have asked my server guy to install it)
anyone have any ideas?
My site uses a mixture of English and Chinese and the search function won't work at all without converting.
All seems to have gone well and the search is now working and the Chinese and English are displaying fine. However, I have a problem when I run a back up (using EE's back up)
It lists this at the top of the page (user name and database name have been replaced by me here)
lock ee_accessory: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_accessory_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_accessory_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_admin: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_admin_log: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_batch_cache: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_camera: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_camera_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_camera_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_category_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_category_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_commerce_template: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_counter: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_counter_index: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_counter_list: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_country_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_country_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_debug_report: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_debug_timer: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_defaults: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_error: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_exhibition: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_exhibition_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_exhibition_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_exhibition_feedback: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_exhibition_to_group: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_frame: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_ftp: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_ftp_to_microthumb: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_ftp_to_size: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_ftp_to_thumb: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_group: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_group_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_group_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_group_to_group: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_language: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_lens: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_lens_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_lens_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_light_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_light_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_link: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_link_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_link_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_link_to_group: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_location: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_login: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_message: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_microthumb_path: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_news: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_news_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_news_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_order_to_exhibition: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_order_to_group: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_order_to_indexpage: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_order_to_link: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_owner: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_owner_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_owner_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_performance: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_photo: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_photo_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_photo_comment: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_photo_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_photo_size: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_photo_to_accessory: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_photo_to_category: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_photo_to_ee_commerce_template: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_photo_to_exhibition: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_prevnext_cache: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_resizemethod: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_resultcache: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_session: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_settings: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_settings_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_settings_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_shorthand: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_size: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_size_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_size_custom_menutext_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_size_custom_menutext_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’lock ee_size_defaults: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_size_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_structure_cache: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_structure_lang_cache: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_style: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_style_template: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_thumb_path: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_thumb_size: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_thumbs: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_uncookied: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_uncookied_settings: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_upload_folder: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_uploader_cache: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_user: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_viewerstyle: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_workflow: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_workflow_chi: Access denied for user ‘username’@'localhost' to database ‘dbname’ lock ee_workflow_eng: Access denied for user ‘username’@'localhost' to database ‘dbname’
Despite this list it still creates a back up and restoring from this back up also seems to work without a problem.
I don't have access to Phpmyadmin on the server right now (it's a Windows server and I have asked my server guy to install it)
anyone have any ideas?