<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif">T Lista!<br></div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif">Sajnos a MaYoR support nem reagált még, és fontos lenne a dolog:</div><div class="gmail_quote"><div dir="ltr"><div style="font-family:verdana,sans-serif"><br></div><div style="font-family:verdana,sans-serif">Megyitnám az új tanévet, beállítom a szemesztereket, megadom az adatbázis admin jelszót, majd:</div><div style="font-family:verdana,sans-serif">=================================</div><div style="font-family:verdana,sans-serif"><span style="padding:4px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">Hiba [1]:</span><span style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)"> </span><span style="padding:4px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">message:sql_db_dropped</span><span style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)"> </span><span style="padding:4px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">naplo_budenzalap_2021</span><br style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)"><span style="font-family:Elusive-Icons;speak:none;font-variant-numeric:normal;font-variant-east-asian:normal;line-height:1;padding:4px;color:red;font-size:12px;background-color:rgba(250,250,250,0.9)"></span><span style="padding:4px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">Hiba [2]:</span><span style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)"> SQL lekérdezési hiba! </span><span style="padding:4px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">mysqli</span><span style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">,</span><span style="padding:4px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">createDatabase#4</span><span style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">,</span><span style="padding:4px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'XzX1qQ1r'' at line 1</span><span style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">,</span><span style="padding:4px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">GRANT SELECT,EXECUTE ON `naplo_budenzalap_2021`.* TO '<span class="gmail_default" style="font-family:verdana,sans-serif"></span>mayor_naplo_read'@'localhost' IDENTIFIED BY 'XzX1qQ1r'</span><br style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)"><span style="font-family:Elusive-Icons;speak:none;font-variant-numeric:normal;font-variant-east-asian:normal;line-height:1;padding:4px;color:red;font-size:12px;background-color:rgba(250,250,250,0.9)"></span><span style="padding:4px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">Hiba [3]:</span><span style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)"> SQL lekérdezési hiba! </span><span style="padding:4px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">mysqli</span><span style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">,</span><span style="padding:4px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">createDatabase#3</span><span style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">,</span><span style="padding:4px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'hvNK89qd'' at line 1</span><span style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">,</span><span style="padding:4px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">GRANT ALL ON `naplo_budenzalap_2021`.* TO 'mayor_naplo'@'localhost' IDENTIFIED BY 'hvNK89qd'</span><br></div><div style="font-family:verdana,sans-serif"><span style="padding:4px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">=====================================</span></div><div><span style="padding:4px;color:rgb(0,0,0);font-size:12px;background-color:rgba(250,250,250,0.9)"><font face="verdana, sans-serif">L<span class="gmail_default" style="font-family:verdana,sans-serif">étre hozza  az adatbázist azzal, hogy a </span></font></span><span class="gmail_default" style="color:rgb(0,0,0);font-size:12px;font-family:verdana,sans-serif"></span><span style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">mayor_naplo_read<span class="gmail_default" style="font-family:verdana,sans-serif"> és a </span></span><span class="gmail_default" style="color:rgb(0,0,0);font-size:12px;font-family:verdana,sans-serif"></span><span style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgba(250,250,250,0.9)">mayor_naplo<span class="gmail_default" style="font-family:verdana,sans-serif"> userek megfelelő jogokat kapjanak hozzá. Itt elbukik és eldobja.</span></span></div><div><span style="font-family:verdana,sans-serif;background-color:rgba(250,250,250,0.9);color:rgb(0,0,0);font-size:12px"></span></div><div><span style="padding:4px;color:rgb(0,0,0);font-size:12px;background-color:rgba(250,250,250,0.9)"><font face="verdana, sans-serif"><span class="gmail_default" style="font-family:verdana,sans-serif"></span>Hogyan mehetek tovább?</font></span></div><div><span style="padding:4px;color:rgb(0,0,0);font-size:12px;background-color:rgba(250,250,250,0.9)"><font face="verdana, sans-serif">Ubuntu 20.04 <span class="gmail_default" style="font-family:verdana,sans-serif">van mySQL 8 verzióval.</span></font></span></div><div><span style="padding:4px;color:rgb(0,0,0);font-size:12px;background-color:rgba(250,250,250,0.9)"><font face="verdana, sans-serif"><span class="gmail_default" style="font-family:verdana,sans-serif"><br></span></font></span></div><div><div class="gmail_default" style="font-family:verdana,sans-serif">Nyilván a verzióváltás miatt dobja a syntax errort, de nem tudom, mit kellene változtatni. A MaYoR napló még a korábbi mySQL verzióra lett kitalálva.</div></div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div><span style="padding:4px;color:rgb(0,0,0);font-size:12px;background-color:rgba(250,250,250,0.9)"><font face="verdana, sans-serif">Köszönöm a segítséget előre is....</font></span></div><div><br></div>-- <br><div dir="ltr" data-smartmail="gmail_signature"><div dir="ltr">Dicső Géza</div></div></div></div><div dir="ltr" data-smartmail="gmail_signature"><div dir="ltr"><div></div></div></div></div>