especifica o host cara o @ depois do user
o % é coringa. GRANT ALL PRIVILEGES ON amarokdb.* TO 'amarokuser'@'%' IDENTIFIED BY '123mudar'; GRANT ALL PRIVILEGES ON amarokdb.* TO 'amarokuser'@'localhost' IDENTIFIED BY '123mudar'; GREPME MySQL-server query failed! (1045) Access denied for user 'amarokuser'@'localhost' (using password: YES) on na" tenta conectar voce no mysql com esse user e ve o que da, qdo vc conseguir resolver isso vai rolar #mysql -h localhost -u amarokuser -p 123mudar se der denied tenta dar um grant diferente. On Sun, Mar 23, 2014 at 8:24 PM, Gilberto F da Silva <[email protected] > wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Sun, Mar 23, 2014 at 05:28:17PM -0300, J. Tozo wrote: > > ops copiei e colei, ta errado. > > > > mysql> GRANT ALL ON amarok.* TO *amarokuser*@localhost IDENTIFIED BY > > 'senha'; > > Segui esses passos porém, o amarok ainda não consegue se conectar ao > MariaDB. > > Welcome to the MariaDB monitor. Commands end with ; or \g. > Your MariaDB connection id is 13 > Server version: 5.5.32-MariaDB MariaDB Server > > Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others. > > Type 'help;' or '\h' for help. Type '\c' to clear the current input > statement. > > MariaDB [(none)]> GRANT ALL PRIVILEGES ON amarokdb.* TO 'amarokuser' > IDENTIFIED BY 'senha'; > Query OK, 0 rows affected (0.00 sec) > > MariaDB [(none)]> GRANT ALL PRIVILEGES ON amarokdb.* TO amarokuser > IDENTIFIED BY '123mudar'; > Query OK, 0 rows affected (0.00 sec) > > MariaDB [(none)]> GRANT ALL PRIVILEGES ON amarokdb.* TO 'amarokuser' > IDENTIFIED BY '123mudar'; > Query OK, 0 rows affected (0.00 sec) > > MariaDB [(none)]> flush privileges; > Query OK, 0 rows affected (0.00 sec) > > MariaDB > > > > amarok: [CollectionManager] initializing > "amarok_collection-mysqlservercollection" > amarok: BEGIN: MySqlServerStorage::MySqlServerStorage() > amarok: Automatic reconnect successfully activated > amarok: connection to mysql failed > amarok: [ERROR__] Could not connect to mysql! > amarok: [ERROR__] [MySqlStorage] "GREPME MySQL-server query > failed! (1045) Access denied for user 'amarokuser'@'localhost' (using > password: YES) on na" > amarok: [MySqlStorage] Initialized thread, count== 1 > amarok: END__: MySqlServerStorage::MySqlServerStorage() [Took: > 0.006s] > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: BEGIN: bool DatabaseUpdater::update() > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: Database version: 0 > amarok: BEGIN: void DatabaseUpdater::createTables() const > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: END__: void DatabaseUpdater::createTables() const > [Took: 0.001s] > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: END__: bool DatabaseUpdater::update() [Took: 0.001s] > amarok: BEGIN: > SqlRegistry::SqlRegistry(Collections::SqlCollection*) > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: END__: > SqlRegistry::SqlRegistry(Collections::SqlCollection*) [Took: 0s] > amarok: BEGIN: virtual int App::newInstance() > amarok: BEGIN: static void App::handleCliArgs() > amarok: END__: static void App::handleCliArgs() [Took: 0s] > amarok: END__: virtual int App::newInstance() [Took: 0s] > bash-4.2$ amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > amarok: [ERROR__] Tried to query an uninitialized m_db! > KCrash: Application 'amarok' crashing... > KCrash: Attempting to start /usr/lib64/kde4/libexec/drkonqi from kdeinit > sock_file=/home/slackware141/.kde/socket-darkstar/kdeinit4__0 > QSocketNotifier: Invalid socket 8 and type 'Read', disabling... > QSocketNotifier: Invalid socket 16 and type 'Read', disabling... > amarok: Fatal IO error: client killed > > - -- > Gilberto F da Silva - [email protected] - ICQ 136.782.571 > Stela dato:2.456.740,453 Loka tempo:2014-03-23 19:52:21 Dimanĉo > - -==- > Se o homem não sabe a que porto se dirige, nenhum vento lhe será > favorável. > -- Sêneca > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.15 (GNU/Linux) > Comment: +---------------------------------------+ > Comment: ! Gilberto F da Silva - ICQ 136.782.571 ! > Comment: ! Slackware 14.1 64 - yahoo gfs1989 ! > Comment: +---------------------------------------+ > > iEYEARECAAYFAlMvbR4ACgkQJxugWtMhGw5qkwCeLXTF3AXZNWFjFwxAjeD+j77T > 3sYAoObk5w788bAUsnKNHFEBKcHlFMI2 > =4Ik5 > -----END PGP SIGNATURE----- > > -- > GUS-BR - Grupo de Usuários de Slackware Brasil > http://www.slackwarebrasil.org/ > http://groups.google.com/group/slack-users-br > > Antes de perguntar: > http://www.istf.com.br/perguntas/ > > Para sair da lista envie um e-mail para: > [email protected] > --- > Você está recebendo esta mensagem porque se inscreveu no grupo "Slackware > Users Group - Brazil" dos Grupos do Google. > Para cancelar inscrição nesse grupo e parar de receber e-mails dele, envie > um e-mail para [email protected]. > Para obter mais opções, acesse https://groups.google.com/d/optout. > -- Grato, J. Tozo _ °v° /(S)\ SLACKWARE ^ ^ Linux _____________________ because it works -- GUS-BR - Grupo de Usuários de Slackware Brasil http://www.slackwarebrasil.org/ http://groups.google.com/group/slack-users-br Antes de perguntar: http://www.istf.com.br/perguntas/ Para sair da lista envie um e-mail para: [email protected] --- Você está recebendo esta mensagem porque se inscreveu no grupo "Slackware Users Group - Brazil" dos Grupos do Google. Para cancelar inscrição nesse grupo e parar de receber e-mails dele, envie um e-mail para [email protected]. Para obter mais opções, acesse https://groups.google.com/d/optout.
