vabole Posted April 7, 2006 Report Share Posted April 7, 2006 Pēc appsrv instalācijas, kura satur arī mysql un php - myadmin, standartā root nav psvrda. Kā, kur nomainīt? Kas jāraksta? Link to comment Share on other sites More sharing options...
Delfins Posted April 7, 2006 Report Share Posted April 7, 2006 RTFM Link to comment Share on other sites More sharing options...
vabole Posted April 7, 2006 Author Report Share Posted April 7, 2006 ?? Link to comment Share on other sites More sharing options...
Kavacky Posted April 7, 2006 Report Share Posted April 7, 2006 Read The Fucking Manual Link to comment Share on other sites More sharing options...
vabole Posted April 7, 2006 Author Report Share Posted April 7, 2006 Un tas ir viss! Cerēju, ka kāds spēs arī latviski paskaidrot.., bet ja neviens nezin vai negrib..psc.. Es visus manuāļus esmu izlasījis, bet pa cik manas php zināšanas nav stipras (pamatus zinu)... Tiešām kāds nevar izpalīdzēt, paskaidrot? Link to comment Share on other sites More sharing options...
goldy Posted April 8, 2006 Report Share Posted April 8, 2006 bet ne jau PHP manuālis jālasa lai nomainītu MySQL root paroli. lasi pareizo manuāli. Link to comment Share on other sites More sharing options...
Grey_Wolf Posted April 8, 2006 Report Share Posted April 8, 2006 meklee sheit Link to comment Share on other sites More sharing options...
v3rb0 Posted April 8, 2006 Report Share Posted April 8, 2006 jā, ticēsim ka esi izlasījis visu manuāli un pats nemāki iekš gūgles šitā ierakstīt? http://www.google.lv/search?hl=lv&q=how+to...l+root+password Link to comment Share on other sites More sharing options...
vabole Posted April 8, 2006 Author Report Share Posted April 8, 2006 (edited) Piekonektojos datubāzei, uzliku root password. Itkā viss ir, bet kad konektojos atkal Error MySQL said: #1130 - Host 'localhost' is not allowed to connect to this MySQL server ?? Visas atļaujas 'root'@'localhost' bija uzliktas. Edited April 8, 2006 by vabole Link to comment Share on other sites More sharing options...
Grey_Wolf Posted April 8, 2006 Report Share Posted April 8, 2006 peec root pasworda mainja ir Jarastertee Mysql.... tas pirmkaart otrkart kaada Mysql vers un kaada PHP vers? Ja mysql 4.1 un PHP 4 tad Mysql ir jaliek USEOLD PASWORD --> tad vinsh uztaisiis paroli ko normaali saprot 4 PHP.. Ja lieto 5 tad jaizmanto i... SQLa f-jas... mysqli_connect().. Link to comment Share on other sites More sharing options...
vabole Posted April 8, 2006 Author Report Share Posted April 8, 2006 No jauna pārinstalēju visu.. Uzinstalētais: Apache Web Server Version 1.3.33 PHP Script Language Version 4.3.11 MySQL Database Version 4.0.24 Meklējot, te:http://www.google.lv/search?hl=lv&q=how+to+change+mysql+root+password atradu šo: how to change mysql root password- First of all you should remove the anonymous user from mySQL by logging into mySQL then running this sql: mysql> DELETE FROM user WHERE host='localhost' AND user=''; Quit mySQL and from the command line run the following (make sure you are in the mysql\bin directory): mysqladmin reload This reloads all the table information and therefore removing the anonymous user. Next, still in the command line: mysqladmin -u root password <your new password> This sets a password for the root user (admin) and your job is done Problēma manā nezināšanā: Tiku līdz:(make sure you are in the mysql\bin directory) Kā palaižu šo mysqladmin no bin directory, pārādās logs uz sekundi un pazūd... Tā tam jābūt? Vai es sapratu visu pareizi-laikam nē? Link to comment Share on other sites More sharing options...
bubu Posted April 8, 2006 Report Share Posted April 8, 2006 start->run->cmd un tad ej uz to bin direktoriju. Link to comment Share on other sites More sharing options...
vabole Posted April 8, 2006 Author Report Share Posted April 8, 2006 (edited) mysqladmin atbilde: unknown variable 'default-character-set=latin1' Latīņu - tak ir angļu. Kas jāmaina? -------------------------------------------------------------------------------------------------------------------------------- Paldies, tiem kas palīdzēja, root password esmu nomainījis. Veicot šādas darbības: Ar mysql query browser, datu bāzē - UPDATE user SET password=password("newpassword") WHERE user="root"; Pēc tam: DELETE FROM user WHERE host='localhost' AND user=''; Pēc tam: mysql serviceuninstall un install Man tas aizņēma veselu dienu, meklēt googlē un atrast pareizo variantu, tas ir nežēlīgi. Ņemot vērā, ka iepriekš man nebija nekādu zināšanu par šo. Vispār! Edited April 8, 2006 by vabole Link to comment Share on other sites More sharing options...
Delfins Posted April 8, 2006 Report Share Posted April 8, 2006 Bļin, izmanto google. tur visas atbildes ir.. Link to comment Share on other sites More sharing options...
eglitis Posted April 8, 2006 Report Share Posted April 8, 2006 Kas tie par risinājumiem? MySQL taču ir brīnišķīgs manuālis, tas arī jāskatās. Vienmēr vispirms jāskatās izmantojamā produkta manuālī/rokasgrāmatā un tikai tad jāmeklē citur. Tad nebūs ne diena meklējumos jāpavada, ne nepārbaudītas metodes jāizmanto (par service uninstall/install flush vietā joprojām nebeidzu brīnīties). http://dev.mysql.com/doc/refman/4.1/en/def...privileges.html Link to comment Share on other sites More sharing options...
Recommended Posts