MySql 5

P

puma75

Verified User
Joined
Feb 10, 2006
Messages
26
I had a clean install of fedora core 4 / direct admin installed.

I upgraded the Mysql rpm to version 5.0.18.

Now in the direct admin control panel when I try and create a new mysql database for a user it says :

Error creating the database

Details

Invalid Database Name


The database name I tried is indigo_db

The indigo_ bit is hard coded onto the page so I just added db onto the end.

Thanks for any help.

Paul
 
I'm guessing here, but don't install mysql rpm, instead download and install the latest mysql from DA using the build scripts.

Check your database admin/password is correct, that you still have the da_admin user listed. Then check to see if the indigo_db database exists in mysql already.
 
Thanks for the answer.

I can't log into the direct admin client area to access downloads because I got direct admin through a 3rd party company so dont have a client id.

I thought direct admin used stock mysql rpms though and didnt compile from source or require any special settings.

The database indigo_db doesnt already exist and the correct password is set in /usr/local/directadmin/conf/mysql.conf for the da_admin user, and this user exists in mysql.

Maybe mysql5 doesnt like _'s in database names?

Thanks
 
It is quite happy with _ in names, as I use mysql 5 in DA.

I installed it using DA's script - in /usr/local/directadmin/scripts there's a mysql.sh script. It does install from rpms, but also performs some other stuff- have a look and see.
 
puma75, you can access all the DA downloads without any kind of password or account.

Jeff
 
Thanks.

Where are the doanloads though, I cant find them anywhere on the site.

I tried running the /usr/local/directadmin/conf/mysql.conf script and it uninstalled the current rpms and installed some new ones (i think!) but I still couldn't create a database though DA control panel.

I can create a database in mysql user_test (for example), then if I log into DA as user the database shows up and I can add mysql users to it ok through DA, so its just a problem with the add database task.
 
puma75 said:
Where are the doanloads though, I cant find them anywhere on the site.
Click to expand...
Here.

But DA doesn't have RPMs for MySQL5, only for version 4.

I tried running the /usr/local/directadmin/conf/mysql.conf script and it uninstalled the current rpms and installed some new ones (i think!) but I still couldn't create a database though DA control panel.
Click to expand...
If I'm remembering correctly you need to run one of the install scripts to install the version of MySQL that DA will use.

You might try this:

Look at the script at: /usr/local/directadmin/scripts

and place the RPMs you want to use where that script expects to find them.

Then run the script. Note that I've not tested this.

Jeff
 
Updated to 5.0.18 using the script mysql.sh and its working fine :)
 
This is the email DSA support sent me when I had an issue with mysql which upgraded it to version 5.

Hello,

Mysql reinstall:

cd /usr/local/directadmin/scripts
./mysql.sh pass1 da_admin pass2

where pass1 and pass2 can be anything you want. Pass1 will be the password for the root mysql user, and pass2 is the password for the da_admin mysql user (which is used to create mysql accounts/databases)

If you're connecting to mysq remotely, then you'd need to add your IP to the access host list for the database you're working on.
User Level -> MySQL Databases -> dbname -> Access Hosts.

Also make sure you don't have a firewall blocking port 3306.

Thank you,

John
--------------------------------------------------

DirectAdmin Web Control Panel
http://www.directadmin.com
Click to expand...
 
yeah... that script only undates mysql to 4.1. I dont know what you are talking about.
 
update your directadmin version, then also check the script itself to see if its explicitly only allowing mysql 5 installation on more recent versions of your operating system
 
jlasman said:
But DA doesn't have RPMs for MySQL5, only for version 4.
Click to expand...

I guess it depends on OS. On CentOS 64bit it installs MySQL 5 by default.
Lucky us :)
 
You must log in or register to reply here.
Back
Top