Armenian Knowledge Base  

Go Back   Armenian Knowledge Base > Technical sections > Languages, Compilers, Interpreters
Register

Reply
 
LinkBack Thread Tools
Old 03.03.2005, 20:04   #1
полюбому йес эм...
 
Mesrop's Avatar
 
Join Date: 02 2005
Location: near the computer
Age: 26
Posts: 3,243
Downloads: 3
Uploads: 0
Reputation: 129 | 3
Exclamation Проблемы с MySQL

Please Help me..
Es chem karoxanum MySQL-i vra USER NAME u PASS dnel .. ov karox e ognel
Reply With Quote
Old 03.03.2005, 20:20   #2
Профессор
 
Nikita's Avatar
 
Join Date: 01 2005
Location: Perm
Age: 38
Posts: 2,142
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

ну ты бы поподрубнее написал об этом
может это тебе поможет
хотя думаю ты это уже читал
Quote:
5.6.5 Assigning Account Passwords

Passwords may be assigned from the command line by using the mysqladmin command:

shell> mysqladmin -u user_name -h host_name password "newpwd"



The account for which this command resets the password is the one with a user table record that matches user_name in the User column and the client host from which you connect in the Host column.


Another way to assign a password to an account is to issue a SET PASSWORD statement:

mysql> SET PASSWORD FOR 'jeffrey'@'%' = PASSWORD('biscuit');



Only users such as root with update access to the mysql database can change the password for other users. If you are not connected as an anonymous user, you can change your own password by omitting the FOR clause:

mysql> SET PASSWORD = PASSWORD('biscuit');



You can also use a GRANT USAGE statement at the global level (ON *.*) to assign a password to an account without affecting the account's current privileges:

mysql> GRANT USAGE ON *.* TO 'jeffrey'@'%' IDENTIFIED BY 'biscuit';



Although it is generally preferable to assign passwords using one of the preceding methods, you can also do so by modifying the user table directly:

To establish a password when creating a new account, provide a value for the Password column:
shell> mysql -u root mysql
mysql> INSERT INTO user (Host,User,Password)
-> VALUES('%','jeffrey',PASSWORD('biscuit'));
mysql> FLUSH PRIVILEGES;


To change the password for an existing account, use UPDATE to set the Password column value:
shell> mysql -u root mysql
mysql> UPDATE user SET Password = PASSWORD('bagel')
-> WHERE Host = '%' AND User = 'francis';
mysql> FLUSH PRIVILEGES;



When you assign an account a password using SET PASSWORD, INSERT, or UPDATE, you must use the PASSWORD() function to encrypt it. (The only exception is that you need not use PASSWORD() if the password is empty.) PASSWORD() is necessary because the user table stores passwords in encrypted form, not as plaintext. If you forget that fact, you are likely to set passwords like this:

shell> mysql -u root mysql
mysql> INSERT INTO user (Host,User,Password)
-> VALUES('%','jeffrey','biscuit');
mysql> FLUSH PRIVILEGES;



The result is that the literal value 'biscuit' is stored as the password in the user table, not the encrypted value. When jeffrey attempts to connect to the server using this password, the value is encrypted and compared to the value stored in the user table. However, the stored value is the literal string 'biscuit', so the comparison fails and the server rejects the connection:

shell> mysql -u jeffrey -pbiscuit test
Access denied



If you set passwords using the GRANT ... IDENTIFIED BY statement or the mysqladmin password command, they both take care of encrypting the password for you. The PASSWORD() function is unnecessary.


Note: PASSWORD() encryption is different from Unix password encryption. See section 5.6.1 MySQL Usernames and Passwords.
Reply With Quote
Old 04.03.2005, 16:29   #3
полюбому йес эм...
 
Mesrop's Avatar
 
Join Date: 02 2005
Location: near the computer
Age: 26
Posts: 3,243
Downloads: 3
Uploads: 0
Reputation: 129 | 3
Arrow OK!

Спасибо!
Isk du gides te vortexic karox em gtnel grakanutyun, PHP GUESTBOOK (MySQL-i vrov) sarqelu Учебник ??
Bayc vor et MySQL БД sarqel@ manramasn lini.. teche esel tenc mi resurs gitem, tenc baner kan.. bayc et moment@ lav chi nkaragrum.. et mas@ makeresayin a talis.. xndrum em tes inch karas anes??
Reply With Quote
Old 04.03.2005, 16:40   #4
Профессор
 
Nikita's Avatar
 
Join Date: 01 2005
Location: Perm
Age: 38
Posts: 2,142
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

2Mesrop
относительно PHP MySQL guestbuk
когда мне лень писать пользуюсь
http://hotscripts.com/
относительно литературы
конечно мануал МайСКЛ немного труден для новичков
но вообще можеш почитать в www.citforum.ru
я именно с него начал, а потом перешел на мануал, он в данном случае оказался мостиком между практикой и теорией СУБД
Reply With Quote
Old 05.03.2005, 21:25   #5
полюбому йес эм...
 
Mesrop's Avatar
 
Join Date: 02 2005
Location: near the computer
Age: 26
Posts: 3,243
Downloads: 3
Uploads: 0
Reputation: 129 | 3
Default

OK. mersi shat.
Reply With Quote
Old 16.03.2005, 13:31   #6
шат харн ем...
 
Barew_dzez's Avatar
 
Join Date: 03 2004
Location: de nayac or eli
Age: 33
Posts: 808
Downloads: 0
Uploads: 0
Reputation: 27 | 3
Default

mesrop, isk du ches ogtagortsum GUI ov cragrer.
inchpisin en MySQL Administrator
phpMyAdmin, EMS MySQL..
ev verchers arden Zend 4 a durs ekel..
inqn el harmar bazyin kpnum a.....
heto kan apachi configuratorner. bayc et im karciqov arden titizutyun a..
Reply With Quote
Old 17.03.2005, 13:32   #7
шат харн ем...
 
Barew_dzez's Avatar
 
Join Date: 03 2004
Location: de nayac or eli
Age: 33
Posts: 808
Downloads: 0
Uploads: 0
Reputation: 27 | 3
Default

Obelix kstati es EMS i masin qo workspace i screenshotic em imacel !!!!

isk Zend 4 i het vonc es? deghern el kan..
Reply With Quote
Old 17.03.2005, 15:25   #8
панаехавший
 
Obelix's Avatar
 
Join Date: 06 2003
Location: форпост
Age: 30
Posts: 4,007
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

Quote:
Originally Posted by Barew_dzez
Obelix kstati es EMS i masin qo workspace i screenshotic em imacel !!!!

isk Zend 4 i het vonc es? deghern el kan..
Lol, EMSe lavn a, voch mi bani het chem poxi.

Zendi hamar el, es sovac mard em, softn internetic em qashum, zendn el dzri chi
Reply With Quote
Old 17.03.2005, 21:56   #9
шат харн ем...
 
Barew_dzez's Avatar
 
Join Date: 03 2004
Location: de nayac or eli
Age: 33
Posts: 808
Downloads: 0
Uploads: 0
Reputation: 27 | 3
Default

Obelix jan es qez mi hat gaxtniq asem
zend 4 @ inetic qashum es... (andeg free tryal es reg @lnum)
heto el gites inch es anum vor lav @lni...
u vse..

es el em inetic qashum
Reply With Quote
Sponsored Links
Reply

Thread Tools


На правах рекламы:
реклама

All times are GMT. The time now is 00:51.


Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.