MySqlde yeni kullanici ekleme...

mysql`e yeni kullanici nasil eklenir diye arastiriken ortaya simdi yazdigim dokuman cikti. Umarim sizinde isinize yarar.

1- once mysql`e giris yapiyoruz.

C:\Program Files\xampp\mysql\bin>mysql -u root

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 16 to server version: 5.0.27-community-nt



Type 'help;' or '\h' for help. Type '\c' to clear the buffer.



2-use mysql; diye komut yaziyouz.



3-

mysql> select user, host, password from user where user = "root";

+------+-----------+----------+

| user | host | password |

+------+-----------+----------+

| root | localhost | |

+------+-----------+----------+

1 row in set (0.21 sec)





diyerekten su anki kullaniciyi kontrol ediyoruz.



4- CREATE USER 'test'@'localhost' ;



mysql> select user, host, password from user where user = "test";



+------+-----------+----------+

| user | host | password |

+------+-----------+----------+

| test | localhost | |

+------+-----------+----------+

1 row in set (0.00 sec)





yeni kullanici ekledik ve kontrol ettik.



5-



UPDATE user SET Password=PASSWORD('test')

WHERE User='root'

FLUSH PRIVILEGES;





bu komut ile kullanciyi ve sifreyi update yapiyoruz.



6-  C:\Program Files\xampp\mysql\bin>mysql -u test -p test

Enter password: ****

ERROR 1044 (42000): Access denied for user 'test'@'localhost' to database 'test'



tekrar mysql`i yeni kullanici adi ve password ile acinca  boyle bir hata gelebilir. Bu durumda;



7- asagidaki sekilde yaparak olayi tamamliyoruz...





mysql> use mysql;

Database changed

mysql> GRANT ALL PRIVILEGES ON *.* TO 'test'@'localhost'

-> IDENTIFIED BY 'test' WITH GRANT OPTION;

Query OK, 0 rows affected (0.00 sec)



mysql> quit

Bye



C:\Program Files\xampp\mysql\bin>mysql -u test -p test

Enter password: ****

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 94 to server version: 5.0.27-community



Type 'help;' or '\h' for help. Type '\c' to clear the buffer.



mysql>





umarim yardimci olmustur.













Technorati Tags: mysql

Powered by ScribeFire.