[Authority] depressed Vanuatu. . . I have never built the MYSQL Based off my password, but also with a start, but I mytest concerned and the test DROP cut and then build on the only form of a test build, for example, I built mytest other so often, occur : [code]ERROR 1044 (42000) : Access denied for user '' @ 'localhost' to database 'mytest' Mysql>[/code] I used -root mysql-u-p groups, the results must be password, but I did not set up the password 阿??? Why??? outside warring false bargain Fail to understand that you do not want to I mean, I MYSQL Based Rennie tables when it emerged ERROR 1044 (42000) : Access denied for user '' @ 'localhost' to database 'mytest' Mistakes. Table construction is not improved. If the password simply to re-look at Zhiding FAQ "how do forget root password." The following are my doubts : 1. You have never been established by a code, how can you previously recorded? Mysql-u root or direct mysql? 2. Later I : : DROP swap concerned here about a problem that is mytest and test data tables or databases? 3. DROP posted to your account then what? And there, too lazy to write the first of these bars, it would be best if you put a detailed process that has little to say about, otherwise you switch back and forth between the two accounts posted, and then asked pulls together problems, I do not know what ah? You are using anonymous users download, authority only to visit the test database. I downloaded MYSQL Based official. No compiler installation. 1, I installed according to the inside of INSTALL. Step which is to create a user ID, my customers, "mysql." I implementation. After /bin/mysql go in without a password. 2, DROP off the show databases; see the exterior. 3, "mysql" user DROP landing the upswing. --> You said that the creation of the user mysql is the establishment of this useradd mysql? Which is the operating system on clients, and is used to start the MySQL services, rather than the download MySQL. Scripts/mysql_install_db implementation of this step, not from a pile of English suggested? You have to use them : . /bin/mysqladmin-H localhost-u root password 'yorpassword' orders to the root@localhost MySQL account to establish passwords. You try to implement this, see also would not then. /bin/mysql -uroot-P download. You use. /bin/mysql This download MySQL, the authority is using a test database. See the show databases database is not table! I was surprised that you use anonymous users into databases can actually show apart from the test outside the database? Mytest there is that the original? Could it be that version? ? ? To tell the truth, MYSQL Based really strange question yo, sometimes really do not know how! I downloaded the 4.0 version to the official. INSTALL-BINARY documents which have to teach you how to install : I installed according to the following steps. No small step. Can be spent on equipment. The last step is to activate. The basic commands that you must execute to install and use a MySQL Binary distribution are : Shell> groupadd mysql Shell> useradd g mysql mysql Shell> cd /usr/local Shell> gunzip "/PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf - Ln-s FULL-PATH-TO-MYSQL-VERSION-OS mysql shell> Shell> cd mysql Shell> scripts/mysql_install_db --user=mysql Shell> chown-R root. Shell> chown-R mysql data Shell> chgrp-R mysql. Shell> --user=mysql & bin/mysqld_safe No input on the user names and passwords can be directly controlled. Yes, the password is not to be able to use MySQL, but the proposal was immediately change the MySQL root password to ensure data security. Shell> scripts/mysql_install_db --user=mysql step in the implementation of, not out a lot of the English suggest? Is to tell you how to set up passwords, etc. How to Start information. Return to the subject, this time with you. /bin/mysql U root is the root posted authority, MySQL server management, of course, can establish the database. At this point you show databases, and the test can see mysql databases. If yes. /bin/mysql Download (but this time you are not the root account in the state system, because if that is not u parameters, then the current system is the tacit consent of the users were recorded as MySQL login users), then ordinary jurisdiction, but is limited to the use of test database. Verifiable databases show no authority to establish the database, the database can only test under the creation, deletion and use data sheets. So, what if you could not be found, you should determine competence is what you download MySQL user accounts, user select () can be seen. The best way to get the book and read your MySQL operating basis, the professional than me. TU. Good. Thank you rardge brother. The landlord, you are obviously not used, said that it was strange. MYSQL Based you look at the competence, authority and acquiescence, and then asked this question right, [ Closed window ]