November 23, 2008 01:10am pst

1. angelIII 840,951
2. hielo 463,136
3. routinet 275,450
4. hernst42 254,855
5. ee_rlee 219,254
6. mankowitz 206,587
7. ushastry 186,962
8. yodercm 155,304
9. fibo 133,310
10. cedlinx 128,742
11. Ray_Pas... 127,511
12. virmaior 126,822
13. leannonn 110,570
14. cxr 88,568
15. adrpo 87,450
16. TerryAtO... 81,800
17. logudotcom 81,165
18. mark_wills 75,635
19. theGhost... 75,523
20. arnold 75,419
21. TomasHelgi 73,674
22. bportlock 72,239
23. nplib 70,560
24. mattaob 69,744
25. teraplane 65,970

1. angelIII 2,196,790
2. todd_far... 1,724,617
3. snoyes_jw 765,508
4. Raynard7 704,144
5. hernst42 613,555
6. Squeebee 555,077
7. leannonn 489,506
8. hielo 467,736
9. ushastry 392,464
10. NovaDeni... 373,934
11. routinet 373,655
12. akshah123 327,468
13. psadac 320,695
14. virmaior 319,088
15. AdrianSRU 317,146
16. yodercm 313,173
17. mankowitz 298,809
18. fibo 277,443
19. ee_rlee 219,254
20. teraplane 193,956
21. ldbkutty 184,558
22. racek 181,131
23. steelseth12 177,995
24. glcummins 176,290
25. gamebits 173,436

07.06.2008 at 02:46PM PDT, ID: 23542068

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.8

Error # 1044 Access denied in MySql. Tried everything.

Asked by pelachile in MySQL Server, Apple Software, Web Authoring

Tags: MySQL AB, MySQL Community Server for OSX 10.5, 5.0.51a

I have installed MySql-5.0.51a-osx10.5-x86_64 on my Intel Mac Book Pro. The install was fine and I am able to start and stop the server with in the Terminal with mysql-start and mysql-stop. I entered some aliases in the ~/.bash_login file. I can get right into the mysql monitor just by running the command mysql from the initial bash prompt, without having to enter in a password or username. However when I do, I get an 1044 error. Acces denied. I can't create, delete, insert, grant or anything worthwhile. I tried to flush privileges but get the same access denied message. I moved and renamed the data file and tried to run mysql_install_db but I got installation of system tables failed message.Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:

           
           
             MacBookPro:mysql Cory$ scripts/mysql_install_db --user=mysql
 
mkdir: ./data/mysql: Permission denied
chmod: ./data/mysql: Permission denied
chown: ./data/mysql: Permission denied
mkdir: ./data/test: Permission denied
chmod: ./data/test: Permission denied
chown: ./data/test: Permission denied
Installing MySQL system tables...
080707  0:10:11 [Warning] Ignoring user change to 'mysql' because the user was set to 'cory' earlier on the command line
 
080707  0:10:11 [Warning] Can't create test file /usr/local/mysql-5.0.51a-osx10.5-x86/data/MacBookPro.lower-test
080707  0:10:11 [Warning] Can't create test file /usr/local/mysql-5.0.51a-osx10.5-x86/data/MacBookPro.lower-test
./bin/mysqld: Can't change dir to '/usr/local/mysql-5.0.51a-osx10.5-x86/data/' (Errcode: 13)
080707  0:10:11 [ERROR] Aborting
 
080707  0:10:11 [Note] ./bin/mysqld: Shutdown complete
 
Installation of system tables failed!
 
Examine the logs in ./data for more information.
You can try to start the mysqld daemon with:
./bin/mysqld --skip-grant &
and use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:
 
shell> ./bin/mysql -u root mysql
mysql> show tables
 
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in ./data that may be helpful.
 
The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!
 
MacBookPro:mysql Cory$
           
         

Keywords: Error # 1044 Access denied in My…

	Title
1	How do I launch Mysql from a BASH s…
2	MYSQL not starting
3	Can't connect to local MySQL server
4	MySQL CONCAT
5	mysql, mysql, 5
6	Postfix mysql lookup not working

Loading Advertisement...

20081112-EE-VQP-44 / EE_QW_2_20070628

Error # 1044 Access denied in MySql. Tried everything.

Asked by pelachile in MySQL Server, Apple Software, Web Authoring

Tags: MySQL AB, MySQL Community Server for OSX 10.5, 5.0.51a

About this solution