o01's questions

I'm having some difficulties with MySQL on my Ubuntu box. Just installed Apache, MySQL, PHP and phpMyAdmin. phpMyAdmin gives:

#1045 Cannot log in to the MySQL server

on every login attempt. I've tried username 'root' and empty password, username 'root' and password 'root', username 'mysql' and password 'mysql', username 'mysql' and password 'root'.

I also get Access denied for user [email protected] error when I try to run mysql in terminal:

mysql -u root

or

mysql -u root -p

or

sudo mysql

or any of the combinations listed above. I also get access denied when I try these:

mysqladmin -u root password secret

sudo /etc/init.d/mysql stop

Even

service mysql stop

gives unknown instance.

So - can anyone tell me how to get into my database? Thanks.

Update:

When I run ps aux | grep mysql I see sudo mysqld --skip-grant-tables.

Update 2:

After reboot I see mysqld running. Then I try service mysql stop and get the following:

user@host:$ service mysql stop
stop: Rejected send message, 1 matched rules; type="method_call", sender=":1.47" (uid=1000 pid=2267 comm="stop mysql ") interface="com.ubuntu.Upstart0_6.Job" member="Stop" error name="(unset)" requested_reply=0 destination="com.ubuntu.Upstart" (uid=0 pid=1 comm="/sbin/init"))

Wtf?

Update 3:

I finally managed to change my root password by using this command:

sudo dpkg-reconfigure mysql-server-5.1

Still have no idea why I couldn't log in before (don't remember setting any password previously). Also, not sure if the deamon now will run correctly after a reboot...

I want to export certain tables from one database and import them to another. The tables in question are used for my MediaWiki installation and are prefixed with "wiki_".

I do not have access to phpMyAdmin, but I am able to connect to the server via SSH. I'm guessing I need to use the mysqldump command, but how do I specify that I only want to dump tables prefixed with "wiki_"?

I've been tasked with modifying an existing Wordpress site with URL rewriting. Problem is I've never done this before. I know these rules should go in a .htaccess file in root with something like this in it:

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule . /index.php [L]
</IfModule>
# END WordPress

However, I have no clue as to how I should specify the rules and conditions for rewriting. I've tried to read up on the mod_rewrite guide, but my somewhat lacking technical abilities limits my comprehension.

Here are the URLs that need rewriting and the desired results:

Generic blog post URL
www.example.com/?p=X
= www.example.com/blog/custom-post-title/

Specific pages
www.example.com/?page_id=2
= www.example.com/about/

www.example.com/?page_id=4
= www.example.com/bloggers/

www.example.com/?page_id=10
= www.example.com/results/

Generic blogger profile
www.example.com/?author=X
= www.example.com/blogger/author-name/

Any help with this would be greatly appreciated. Thanks in advance!

When I add an empty .htaccess file to server root (touch .htaccess) I get a 403 error. The samme error appears no matter what I put in the file (I've tried specifying <LIMIT> directives etc).

Example of auth directive I've tried:

<Limit GET POST>
  Order deny,allow
  AuthType Basic
  AuthUserFile /path/to/file
  AuthName "Tits for Haiti etc"
  Require valid-user
</Limit>

Whats the deal?

This question was first posted to Stack Overflow, but as it is perhaps just as much a server issue I though it might be just as well to post it here also.

I have just installed and configured Apache, MySQL, PHP and phpMyAdmin on my Macbook in order to have a local development environment. But after I moved one of my projects over to the local server I get a weird MySQL error from one of my calls to mysql_query():

Access denied for user '_securityagent'@'localhost' (using password: NO)

First of all, the query I'm sending to MySQL is all valid, and I've even testet it through phpMyAdmin with perfect result. Secondly, the error message only happens here while I have at least 4 other mysql connections and queries per page. This call to mysql_query() happens at the end of a really long function that handles data for newly created or modified articles. This basically what it does:

1. Collect all the data from article form (title, content, dates, etc..)
2. Validate collected data
3. Connect to database
4. Dynamically build SQL query based on validated article data
5. Send query to database before closing the connection

Pretty basic, I know. I did not recognize the username "_securityagent" so after a quick search I came across this from and article at Apple's Developer Connection talking about some random bug:

Mac OS X's security infrastructure gets around this problem by running its GUI code as a special user, "_securityagent".

Then I tried put a var_dump() on all variables used in the mysql_connect() call, and every time it returns the correct values (where username is not "_securityagent" of course). Thus I'm wondering if anyone has any idea why 'securityagent' is trying to connect to my database - and how I can keep this error from occurring when I call mysql_query().

Update: Here is the exact code I'm using to connect to the database. But a little explanation must follow:

1. The connection error happens at a call to mysql_query() in function X in class_1
2. class_1 uses class_2 to connect to database
3. class_2 reads a config file with the database connection variables (host, user, pass, db)
4. class_2 connect to the database through the following function:

var $SYSTEM_DB_HOST = "";

function connect_db() {

// Reads the config file
include('system_config.php');

if (!($SYSTEM_DB_HOST == "")) {
    mysql_connect($SYSTEM_DB_HOST, $SYSTEM_DB_USER, $SYSTEM_DB_PASS);
    @mysql_select_db($SYSTEM_DB);

    return true;
} else {
    return false;
}
}