Jump to content


Photo

MYSQL ERROR


  • Please log in to reply
8 replies to this topic

#1 richarro123

richarro123
  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 05 September 2003 - 01:13 AM

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

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 05 September 2003 - 05:21 AM

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.
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#3 richarro123

richarro123
  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 05 September 2003 - 02:51 PM

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

#4 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 06 September 2003 - 05:36 AM

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.
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#5 richarro123

richarro123
  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 06 September 2003 - 10:06 PM

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

#6 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 08 September 2003 - 05:19 AM

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.
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#7 richarro123

richarro123
  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 08 September 2003 - 07:00 PM

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:

#8 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 09 September 2003 - 05:48 AM

Have a look at this

http://www.mysql.com...privileges.html
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#9 richarro123

richarro123
  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 10 September 2003 - 12:06 AM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users