FREEBSD / mysql..:?

[Dolemite50]

Hi,
I am trying to create a database while logged in to freebsd. My login for the site has a username of "kyle".
I am trying to create a table but it adds "kyle_" to the front of the tablename. So if I tell it to create a database named "data" it sends back:

Sql Account Maintenance

Database Created
Added the database data.

But when I go back I see that it actually created a database named kyle_data.

Any suggestions?

Thanks.

[LordShryku]

Is this a host? They usually set that up to keep track of who owns what database...

[Dolemite50]

Thanks Lord,
So this is by design then? I should just switch all of my php code over to have a kyle_ in fron of it? No prob, I can do that. I am curious though, I was not able to find a way to import any pre-existing mysql databases into it.

[LordShryku]

Well, if your host has this setup, you'd be safe to change your database selections to kyle_dbname. As far as import, if you have your tables dumped, can upload that sql file, and can hit the mysql binary, this will be real easy. From there it's just:

/path/to/mysql -u kyle -p<password> kyle_dbname < /path/to/sqlfile.sql