mysql privileges

[bnetfire]

How do i change my mysql users privileges to max?

[bnetfire]

ah also does this have FTP server? so i can connect and use my FTP manager?

And yes ive already read the FAQ's says nothing about how to change privileges on mysql and i saw the FTP part but when i click on the link i get an error saying cannot connect to server or something like that

[UnlimitedMB]

you already have full mysql privileges.
you need ftp software to use ftp, not your browser.

[bnetfire]

Thats not what mine says, No Privileges

I expored a DB from a nother Host and im wanting to import the DB to this host but when i do that it says

-- phpMyAdmin SQL Dump
-- version 2.8.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 03, 2008 at 02:29 AM
-- Server version: 5.0.27
-- PHP Version: 4.3.10-16
--
-- Database: `smallfri_smf`
--
CREATE DATABASE `smallfri_smf` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user '12004_bnetfire'@'' to database 'smallfri_smf'

And for FTP im useing filezilla i just dont know the settings to connect to my manager..

Host: ?
Username: bnetfire
Password: *******

i just dont know what to put for host

[wwe]

You use ftp.ulmb.com as the host.

Your username is your site name. (The one you're planning on working on. Don't put "http://" infront of the url. Just type your "username" as "yourdomain.com")

Your password remains the same.

[UnlimitedMB]

If you want to create more databases you must use the MySQL icon in your control panel, not phpmyadmin.

phpmyadmin is used to manage existing databases, not create new ones.
You already have a database "12004_bnetfire" and cannot create one named "smallfri_smf"

EDIT: Yes i see what the problem is now, you exported it wrong from your old host.
You need to export the tables not the database itself.

[bnetfire]

well on my old host i run a forum and im trying to export is ALL posts, forums, boards, info, posts and stuff like that but i dont get what you mean by exporting the tables not the database?

[UnlimitedMB]

Edit the .sql file you downloaded with a text editor

Remove the two lines
CREATE DATABASE xxxx
USE xxxxx

Save the changes and upload.

You will also need to edit the config.php of your script to insert your new database info for our server, since it will be different from that used at your old host.

[bnetfire]

i though about that but im useing SMF and couldnt i just install the REpair script for SMF and change the SQL database from there?

Edit: I removed thoughs stuff and now i get this error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 03, 2008 at 06:25 PM
-- Server version: 5.0.27
-- PHP Version: 4.3.10-16
--
-- Database: `smallfri_smf`
--
-- --------------------------------------------------------
--
-- Table structure for table `smf_attachments`
--
DROP TABLE IF EXISTS `smf_attachments` ;

MySQL said: Documentation
#1046 - No database selected

[UnlimitedMB]

You have to select the database first in the left column of phpmyadmin.

It will be much easier to import the backup by clicking on the [Backup] link in the MySQL area of the ulmb control panel, this is the recommended way and is preferable to phpmyadmin.

[bnetfire]

ohh it worked thank you so much man much appreciated :D

now to upload the scripts and see if it all works.

Edit: hmm what do i put as my user name for my FTP

Host:ftp.ulmb.com
Username:bnetfire <-- didnt work
Password:******

Response: 331 User bnetfire OK. Password required
Command: PASS *******
Response: 530 Login authentication failed
Error: Could not connect to server

Edit: Never mind fixed now to see if the uploading of the scripts are ok.

[bnetfire]

..... ahh poo

i ran repair_settings.php for my SMF
i put in the corrent database settings
Databse name: 12004_bnetfire
Username: 12004_bnetfire
Password: *************

and i would switch the paths to the corrent ones for this host and save
Then when i would go to the ULR where the files are it says

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

Bah nevermind i had the server set on localhost when it was supposed to be mysql

Fixed and my site is up and running 100% thanks for your help.