Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
i'm a total newb to mysql but i really want to run drupal on my newly acquired web server,
but i keep getting a wrong password error when trying to log in as a user i just made for the mysql database , when it should'nt have a password.? is there some kind of default?
I took a brief look at the drupal.org site. Per the installation instructions, you should have done this:
Quote:
mysqladmin -u dba_user -p create drupal
MySQL will prompt for the 'dba_user' database password and then create
the initial database files. Next you must login and set the access
database rights:
mysql -u dba_user -p
Again, you will be asked for the 'dba_user' database password.
At the MySQL prompt, enter following command:
GRANT ALL PRIVILEGES ON drupal.*
TO nobody@localhost IDENTIFIED BY 'password';
where
'drupal' is the name of your database
'nobody@localhost' is the username of your webserver MySQL account
'password' is the password required to log in as the MySQL user [/quote]
after i install mysql with pkgtool i run the command: mysql -u root -p create drupal
since the database is going to be for drupal. The guide that i'm using says that it should prompt me for a password but it never does ?
root@chaos:~# mysqladmin -u dba_user -p create drupal
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!
<= I GOT THESE RESULTS:
./mysqlaccess.conf
./init.d/mysql
./logrotate.d/mysql
Since your mysql start script isn't in /etc/init.d, my next guess would be it's in /etc/rc.d/init.d. Either way, the above "find" command (note the quotes (") and the asterisk (*)) should locate it for you.
PS:
Feel free to contact me directly by e-mail, if you don't want to clutter this thread with extraneous "noise". As I see it, the things we need to do are:
1. Make sure mysql is up and running
2. Create your "dba user" (if you haven't already)
3. Create your database (f you haven't already)
4. Finish the basic install
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!
2. This shows that it apparently won't start, even manually:
Quote:
root@chaos:/etc# /etc/rc.d/rc.mysqld start
root@chaos:/etc# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/mysql.pid
050904 22:23:31 mysqld ended
3. As you already know, this strongly suggests that the mysql install failed. Here is a link to the mysql install page:
4. I'm also concerned that I don't see a mysql log file
EXAMPLE: /var/lib/mysql/mysqld.log
Speculation: maybe there's a permissions error?
Maybe the *same* permissions error is both preventing your
log file from being written as is preventing mysql itself from
coming up?
Any in case, please feel free to contact me via e-mail, and/or post to LQ, however you see fit.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
