mysql problhma

[Vasileios]

paidia kalhspera

8elw na kanw mia efarmogh basismenh sthn mysql.

katebasa to teleutaio release apo to site ths mysql.ekana kanonika ola ta configurations.

ekana ena neo instanse me username, password kai hostname localhost.

otan anoigw to mysql administrator na kanw log in moy bgazei to sunh8es error 1045 access denied for user ..

mhpws exete kata nou kati?

[Hatman]

o user pou exeis ftaxei sto configuration legetai root kai password ayto pou evales.

 

Mhpws vazeis kati allo?

[Vasileios]

to username kai to password einai test kai to hostname localhost.ayta xrhsimopoiw kai sto instance poy ekana kai sto mysql administrator

[Hatman]

oxi

username:root

password:oti eixes valei px test.

 

Meta to onfiguration mono o user root yparxei.

To localhost einai swsto.

[Vasileios]

ekei poy dhlwnw to username na balw root kai password na balw ayto poy 8a dinw kai sto mysql admi?

[Hatman]

Nai alla prepei pali na syndetheis san root gia na dwseis rights!

 

Ean exeis kanei kainourio user tote o user den exei rights gia pouthena apo default. prepei na tou dwseis rights:

 

http://dev.mysql.com/doc/refman/5.1/en/grant.html

[Vasileios]

8a to koita3w file moy giati ta exw parei asxhma

se euxaristw para poly pantws

[kickeras]

an xrisimopoieis mysqli extensions sindeesai ws:

object oriented style

$mysqli = new mysqli("localhost","root","admin","mydatabase");

i procedural style

mysqli_connect("localhost", "root", "admin", "mydatabase");

an xrisimopoieis mysql extensions tote:

$db=mysql_connect ("localhost", "root", "admin") or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db ("mydatabase");

afta se php...

[Vasileios]

file kickera to problhma moy den einai ston programmatismo alla sthn arxikh sundesh

pws 8a mpw sthn bash dedomenwn...me to mysql admin kai tetoia

8emata login loipon

mhpws einai eukolo na me ka8odhghsete apo thn arxh me to setup ti ru8miseis na kanw sas parakalw?

[kickeras]

e afta sou grapsa kai gw.....username:root, password:admin...afta einai ta default.

sto installation ennoeis? an nai dialegeis typical, skip sign up, tikare to configure mysql server, meta dialekse detailed configuration, developer machine, multifunctional database, DSS, kai sta user pass vale admin, admin kai tikare to root blah blah.

meta p.x. apo command line pas sto bin dir tis mysql kai grafeis mysql -u root -p, meta dineis password admin kai mpikes.

afta an katalava kala to provlima sou

 

a kai des edw http://www.google.gr/search?hl=en&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=error+1045+access+denied+for+user&spell=1

[Vasileios]

file kickera se eyxaristw para poly...

8a to prospa8hsw

na eisai kala