| View previous topic :: View next topic |
| Author |
Message |
Pekx
Joined: 09 Sep 2004
Posts: 559
|
 Posted: 22.11.2004 15:31 Post subject: php my admin |
  |
|
ola,!! 
slabo se snalazim u njemu, pa me zanima kako pomoću SQL query-a krirati bazu i kako joj dodijeliti odgovarajući username i pass?
Hvwala!!   |
_________________
mp3hr.com |
|
| Back to top |
|
 |
silence
Joined: 24 Apr 2004
Posts: 890
Location: .....ni na nebu, ni na zemlji.....
|
| Posted: 22.11.2004 17:58 Post subject: |
|
|
urm....zašto pomoći SQL query kad se ne snalaziš u njemu toliko, a imaš krasan komadić phpmyadmina u kojem piše ->
Napravi novu bazu..klik....
imap i napravi tabele....
username i password su ti pod "privilegijama"..bar kolko znam ovak na pol budan, ak sam zeznuo, nek me neko ispravi |
_________________
This End-User License is an agreement between Microsoft Corporation (hereafter referred to as "Microsoft") and you, the end-user (hereafter referred to as "our bitch"). |
|
| Back to top |
|
|
Pekx
Joined: 09 Sep 2004
Posts: 559
|
| Posted: 22.11.2004 22:24 Post subject: |
|
|
ma znam to, ali me baš zanima kako to ide znakovima  |
_________________
mp3hr.com |
|
| Back to top |
|
|
kliker
Joined: 10 Sep 2003
Posts: 800
Location: /var/tmp
|
| Posted: 22.11.2004 23:44 Post subject: |
|
|
hm, nisam siguran, ali mislim da s njim ne mozes definirati usera i pwd za mysql.
manipulacija bazama i tabelama moze, ali za kreiranje usera nisam siguran, mislim da to mora napraviti admin baze direktno u mysql shellu.
phpmyadmin je ipak samo korisnički tool (i to dobar), a ne administratorski. |
|
|
| Back to top |
|
|
klipi
Joined: 23 Nov 2004
Posts: 2
|
| Posted: 23.11.2004 01:32 Post subject: |
|
|
fino u docs direktorij od mysql-a i pokreni help...tamo nadji
3.3.1 Creating and Selecting a Database
5.5.4 Adding New Users to MySQL
ali ako si lijen evo:
kreiraj bazu: CREATE DATABASE PETROVABAZA;
kreiraj usera petar sa sifrom petarsifra i da user petar ima sve privilegije na svim bazama(*.*):
GRANT ALL PRIVILEGES ON *.* TO petar@localhost IDENTIFIED BY 'petarsifra' WITH GRANT OPTION; |
|
|
| Back to top |
|
|
Pekx
Joined: 09 Sep 2004
Posts: 559
|
| Posted: 23.11.2004 17:22 Post subject: |
|
|
| tnx |
_________________
mp3hr.com |
|
| Back to top |
|
|
raytech
Joined: 17 Mar 2004
Posts: 396
Location: Zagreb
|
| Posted: 23.11.2004 17:49 Post subject: |
|
|
| odgovarajući username i password dodjeluješ,izvan php my admina. Tj na cpanelu tvog accounta. |
_________________
http://www.neonski.com | |
|
| Back to top |
|
|
liban0n
Joined: 10 Feb 2004
Posts: 128
Location: Dubrovnik, Zagreb
|
| Posted: 26.11.2004 09:38 Post subject: |
|
|
Iskreno prvi put kad sam upalio phpmyadmina nije mi se svidio.
Perke ???
Zato sto sve volim znat 
ako vec idem nesto uciti onda idem to uciti kako treba. Od kreiranja tablica,rad sa bazom,dropanje ... i ine gluposti oko toga.
Jest da je to "tezi" nacin ali na taj nacin ce te i nauciti nesto sto ce vam biti od koristi.
I naucit ce te kako cijela stvar funkcionira. I onda ce isto tako biti pozicija gdje necete imati taj "admin" i sta onda .. banana |
_________________
mount -t swap /dev/brain /mnt/head
look'n for a job |
|
| Back to top |
|
|
silence
Joined: 24 Apr 2004
Posts: 890
Location: .....ni na nebu, ni na zemlji.....
|
| Posted: 26.11.2004 16:03 Post subject: |
|
|
| liban0n wrote: |
I naucit ce te kako cijela stvar funkcionira. I onda ce isto tako biti pozicija gdje necete imati taj "admin" i sta onda .. banana |
bio sam u takvoj poziciji, nisu imali phpmyadmin...uploado sam ga gore  ..... 
da moram, mogo bi napista sve u SQLu, ali sam ljen i imam phpmyadmin da to radi za mene....
prilično jednostavno |
_________________
This End-User License is an agreement between Microsoft Corporation (hereafter referred to as "Microsoft") and you, the end-user (hereafter referred to as "our bitch"). |
|
| Back to top |
|
|
|
Forum FAQ
Search
Memberlist
Forum ignore list
Register
Profile
Log in to check your private messages
Log in
