MYSQL ERROR

[richarro123]

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

[shivabharat]

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.

[richarro123]

ok thanx man but how do u login like i said i only downloaded it 2 days ago lol?

[shivabharat]

mysql -u root I am just entering my user name and no passowrd is supplied

 

C:mysqlbin>mysql -u root

Welcome 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 -p

Enter 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.

[richarro123]

ok i managed to login but how do u change the privaliges lol

i feel so dumb lol

[shivabharat]

Have a look at this

 

C:mysqlbin>mysql -u admin -p

Enter 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.

[richarro123]

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:

[shivabharat]

Have a look at this

 

http://www.mysql.com/doc/en/Default_privileges.html

[richarro123]

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