mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '<********************>'
When you entered this you did not have the < > at both ends of the password did you????
mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '<********************>'
When you entered this you did not have the < > at both ends of the password did you????
sure, is like 'xxxxxxxxxxxxx'
I saw what you missed now. You forgot the ; at the end of the command to close the statement
Can you get in the webmanagement??? with mysql root user and pass???
I was just going to say he could change it in the mywebsql... but if that works above mark as solved.
@HK: i will try with ; at the end
@tekkbebe: no
root@HPNAS:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 202
Server version: 5.5.38-0+wheezy1 (Debian)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'xxxxxxxxxxxxxxxxx';
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Alles anzeigen
Do you see the management page when you go to that tab???
Did you change default port or bind address???
if I enable SQL management I received:
Failed to execute command 'export LANG=C; invoke-rc.d 'mysql' stop 2>&1': Stopping MySQL database server: mysqld failed!
invoke-rc.d: initscript mysql, action "stop" failed.
and nothing is happen. I have no access to management tab or budy web interface.
port: 3306.
i I have fresh installation of MySQL plugin and if I change something on web interface, I received:
Failed to execute command 'export LANG=C; invoke-rc.d 'mysql' stop 2>&1': Stopping MySQL database server: mysqld failed!
invoke-rc.d: initscript mysql, action "stop" failed.
Error #4000: - this is my error
it is strange, i have a fresh install of OMV 1.0.21 and I use my NAS only for my multimedia content (samba shares) and MySQL plugin for my Kodi/xbmc (OpenELEC) setup. without any customizations.
OMV 0.5 was for me very stable for more than 1 year.
I also follow this post: mySQL Plugin
That post for MySQL is for OMV .5x, not OMV 1. OMV 1 does not use SQL Buddy anymore. We need to get you in the mywebaql management page. At the bottom of the Settings page for MySQL did you enable the SQL management site????
sorry, I was familiar with SQL Buddy in OMV 0.5.
NO, I can not do anything after installing the SQL plugin. Always I received Error #4000.
You get that error because if the debian-sys-maint user is missing its privileges the mysql service can't start, stop or check its status.
Oh, it seems you should run that command as this mysql_upgrade -u root -p.
@'tekkb
404 Not Found
nginx
@HK
root@HPNAS:~# mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run /mysqld/mysqld.sock'
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run /mysqld/mysqld.sock'
MyMusic46.album OK
MyMusic46.album_artist OK
MyMusic46.album_genre OK
MyMusic46.albuminfosong OK
MyMusic46.art OK
MyMusic46.artist OK
MyMusic46.content OK
MyMusic46.discography OK
MyMusic46.genre OK
MyMusic46.karaokedata OK
MyMusic46.path OK
MyMusic46.song OK
MyMusic46.song_artist OK
MyMusic46.song_genre OK
MyMusic46.version OK
MyVideos78.actorlinkepisode OK
MyVideos78.actorlinkmovie OK
MyVideos78.actorlinktvshow OK
MyVideos78.actors OK
MyVideos78.art OK
MyVideos78.artistlinkmusicvideo OK
MyVideos78.bookmark OK
MyVideos78.country OK
MyVideos78.countrylinkmovie OK
MyVideos78.directorlinkepisode OK
MyVideos78.directorlinkmovie OK
MyVideos78.directorlinkmusicvideo OK
MyVideos78.directorlinktvshow OK
MyVideos78.episode OK
MyVideos78.files OK
MyVideos78.genre OK
MyVideos78.genrelinkmovie OK
MyVideos78.genrelinkmusicvideo OK
MyVideos78.genrelinktvshow OK
MyVideos78.movie OK
MyVideos78.movielinktvshow OK
MyVideos78.musicvideo OK
MyVideos78.path OK
MyVideos78.seasons OK
MyVideos78.sets OK
MyVideos78.settings OK
MyVideos78.stacktimes OK
MyVideos78.streamdetails OK
MyVideos78.studio OK
MyVideos78.studiolinkmovie OK
MyVideos78.studiolinkmusicvideo OK
MyVideos78.studiolinktvshow OK
MyVideos78.tag OK
MyVideos78.taglinks OK
MyVideos78.tvshow OK
MyVideos78.tvshowlinkpath OK
MyVideos78.version OK
MyVideos78.writerlinkepisode OK
MyVideos78.writerlinkmovie OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv 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
mysql.user OK
Running 'mysql_fix_privilege_tables'...
OK
Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!