richarro123 Posted September 5, 2003 Share Posted September 5, 2003 hey all i have a problem with mysql. i have only just downloaded mysql,php and paache web server but it wont let me log into mysql to add a database and stuff i have set a password and i can remember it but i dont know how to login. can someone please help me A.S.A.P thanx rich Quote Link to comment Share on other sites More sharing options...
shivabharat Posted September 5, 2003 Share Posted September 5, 2003 I am not sure if you have set password for the deafult user you can try logging in as \"root\" with <blank> password Once you are able to login then try changing the previlage of the user you created. You can download the SQLYOG (www.sqlyog.com) a GUI based tool which can be handy. Quote Link to comment Share on other sites More sharing options...
richarro123 Posted September 5, 2003 Author Share Posted September 5, 2003 ok thanx man but how do u login like i said i only downloaded it 2 days ago lol? Quote Link to comment Share on other sites More sharing options...
shivabharat Posted September 6, 2003 Share Posted September 6, 2003 mysql -u root I am just entering my user name and no passowrd is supplied C:mysqlbin>mysql -u rootWelcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 1 to server version: 4.1.0-alpha-max-nt To supply password mysql -u <login_name> -p C:mysqlbin>mysql -u admin -pEnter password: ***** Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 to server version: 4.1.0-alpha-max-nt Type \'help;\' or \'h\' for help. Type \'c\' to clear the buffer. mysql> If you are using windows you can downlaod SQLYOG www.sqlyog.com a GUI tool whcih can help you a lot. Quote Link to comment Share on other sites More sharing options...
richarro123 Posted September 6, 2003 Author Share Posted September 6, 2003 ok i managed to login but how do u change the privaliges lol i feel so dumb lol Quote Link to comment Share on other sites More sharing options...
shivabharat Posted September 8, 2003 Share Posted September 8, 2003 Have a look at this C:mysqlbin>mysql -u admin -pEnter password: ***** Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 20 to server version: 4.1.0-alpha-max-nt Type \'help;\' or \'h\' for help. Type \'c\' to clear the buffer. mysql> use mysql Database changed mysql> select * from user; +-----------+-------+------------------+-------------+-------------+-------------+-------------+---- ---------+-----------+-------------+---------------+--------------+-----------+------------+-------- ---------+------------+------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Cre ate_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | Referen ces_priv | Index_priv | Alter_priv | +-----------+-------+------------------+-------------+-------------+-------------+-------------+---- ---------+-----------+-------------+---------------+--------------+-----------+------------+-------- ---------+------------+------------+ | localhost | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | % | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | localhost | | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | % | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | localhost | admin | 43e9a4ab75570f5b | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | +-----------+-------+------------------+-------------+-------------+-------------+-------------+---- ---------+-----------+-------------+---------------+--------------+-----------+------------+-------- ---------+------------+------------+ 5 rows in set (0.00 sec) mysql> Table structure Field Type Collation Null Key Default Extra --------------- ---------------------------------- ----------------- ------ ------ ------- ------ Host char(60) character set latin1 latin1_swedish_ci PRI User char(16) character set latin1 latin1_swedish_ci PRI Password char(16) character set latin1 latin1_swedish_ci Select_priv enum(\'N\',\'Y\') character set latin1 latin1_swedish_ci N Insert_priv enum(\'N\',\'Y\') character set latin1 latin1_swedish_ci N Update_priv enum(\'N\',\'Y\') character set latin1 latin1_swedish_ci N Delete_priv enum(\'N\',\'Y\') character set latin1 latin1_swedish_ci N Create_priv enum(\'N\',\'Y\') character set latin1 latin1_swedish_ci N Drop_priv enum(\'N\',\'Y\') character set latin1 latin1_swedish_ci N Reload_priv enum(\'N\',\'Y\') character set latin1 latin1_swedish_ci N Shutdown_priv enum(\'N\',\'Y\') character set latin1 latin1_swedish_ci N Process_priv enum(\'N\',\'Y\') character set latin1 latin1_swedish_ci N File_priv enum(\'N\',\'Y\') character set latin1 latin1_swedish_ci N Grant_priv enum(\'N\',\'Y\') character set latin1 latin1_swedish_ci N References_priv enum(\'N\',\'Y\') character set latin1 latin1_swedish_ci N Index_priv enum(\'N\',\'Y\') character set latin1 latin1_swedish_ci N Alter_priv enum(\'N\',\'Y\') character set latin1 latin1_swedish_ci N I know this is confusying. Download the tool I told SQLYOG thats really helpful. Quote Link to comment Share on other sites More sharing options...
richarro123 Posted September 8, 2003 Author Share Posted September 8, 2003 ok new problem i whent to the mysql bin folder and opend mysqld which is wot it is then it came up with the mysql> thing anyway i dunno if that means im already logged in but i went to type use database and it just shows an arrow under it like this mysql> -> and normally u have to do ; or g so i tried them and it said ERROR 1044: access denied for user: \'root@localhost\' to database \'mysql\' so i tried loggin in agen and i kept gettin that same error massage i tried loggin in as admin usin admin as pass and got access denied then admin no pass then it came up with mysql> but then i did use mysql agen and still got access denied and before u say it i downloaded sqlyog and it wont let me do anything on there i still get access denied for user @localhost. i have come to one conclusion: MYSQL SUX ASS COZ I CANT DO IT i really want it to get sorted coz i am settin up my own buisness and i need a mysql database for all my sellin items and staff and customers but i cant get it sorted!!!!!!!!!.. :evil: :evil: Quote Link to comment Share on other sites More sharing options...
shivabharat Posted September 9, 2003 Share Posted September 9, 2003 Have a look at this http://www.mysql.com/doc/en/Default_privileges.html Quote Link to comment Share on other sites More sharing options...
richarro123 Posted September 10, 2003 Author Share Posted September 10, 2003 i had a look at it but it didnt make much sense i understood a bit of it so i done the easiest thing i cud..... uninstalled mysql and then re-installed it agen lol thanx for all ur help u never no i might need it agen sometime very soon lol Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.