Setting Up A MySQL Server With SBC Webhosting
So I got into my Database Tools section and all I have is this:
* Documentation
* File Importer
* Monitor Table maintenance and testing
* Schema Viewer View table definitions
* Database Dumper Export table contents and definitions
Special Notes:
* Access to your MySQL Database will require that you supply your userid and password.
* Download myodbc, a Windows 95/NT ODBC Client, from the MySQL Homepage.
* For ODBC access use port 3306.
There is NOTHING that tells me WHERE to access my MySQL Database, and myODBC does nothing for me because I don't know where my Database is (I've tried using it to in various ways and can't get anywhere). I have no idea what to do with that port number. Could someone help me out?
View Complete Forum Thread with Replies
Related Forum Messages:
Connecting To Yahoo Webhosting MySQL Sites
1. I've signed up for yahoo webhosting because they had MySQL 2. Installed their phpadmin tools and setup the admin username / password for my db's, create one db and table 3. I downloaded and installd the MySQL GUI tools 4. Pointed MySQL admin to my domain name with un/pw default port 3306 And all I get is "Can't connect to MySQL server on domain name (10060)
View Replies !
Setting Up The Server
I keep getting an error number 1045 access denied whenever I try to run MYSQL Administrator. I just set this up. What did I forget to do? I installed MySQL Server 5.0, the administrator, the query browser and the system tray monitor. What am I forgetting to do here?
View Replies !
Setting Max_allowed_packet On Server Restart
I can't seem to set max_allowed_packet on server restart. Typically, to set it higher I've been restarting mySQL through the command prompt using the --max_allowed_packet=64M, but I want this to happen by default on server restart. I tried editing my my.ini file with no success. I've tried adding the lines: max_allowed_packet=64M --max_allowed_packet=64M max_allowed_packet=64M max_allowed_packet=67108864 and --max_allowed_packet=67108864 Still, on server restart it always is the default 1048576.
View Replies !
Strange Password Setting Behavior In Fedora Core 4 (server 4.1.11)
I have tried adding users aided by several references and this typifies the procedure: http://dev.mysql.com/doc/mysql/en/adding-users.html But, I found that after adding them, I could not use them to get into mysql. I found my way to this reference, http://dev.mysql.com/doc/mysql/en/access-denied.html and on a hunch, set the password to '', that is, no password at all and find that now I can use them to get in. What is going wrong here? Also, I am finding that I cannot get into my database from a remote host, even though I use the '%' variable or even more directly, the actual 'RemoteHost' name.
View Replies !
Setting Up MySQL On Mac OS X
I'm a novice Unix user, and I can't get MySQL set up properly on my Mac. It seems to have installed OK, but when I try to run the mysql_install_ db script, I get errors. I can't set the root password either that the documentation tells me to. As background, I just want to use MySQL to work with databases and PHP and HTML to set up web pages for database input and output. I'm running MySQL on my own machine at home, and have no use for passwords or any other administrative functions. I'm just looking to use the program to set up and query databases. Can anyone point me to a way to avoid all the UNIX admin stuff and run the database? I can get in, but the mysql database doesn't appear when I hit SHOW DATABASES as the tutuorial says, and I can't access or create new databases. I think all this may have something to do with my user account on my machine, but I'm not savvy enough to know how to override permissions, be root, or any of that stuff. Any hints?
View Replies !
Setting Mysql
I'm setting up mysql server for the first time and after logging into the command prompt I setup a new super user and deleted the root user for security reasons. Now it seems I can't login to the server at all. MUST you have a root user to run a mysql server? If not, how can I login to do anything?
View Replies !
Re-setting Mysql As A Service
I installed mysql server 4.1 last month. When I installed it, I set it to run as a service to start automatically. However, for some reason, that no longer occurs. I can't even see the mysql service running from services viewer in win xp. I now have to manually start mysql server each time I reboot. Can someone please tell me how I can Re-set mysql to run as a service?? Or, if I re-install mysql, will it retain the db's already created??
View Replies !
Help With Setting Up A MYSQL Database
I’d like help with developing a mysql database please. The situation is as follows: There are 40 teachers at our institution. Each teacher teaches 4 lessons (I’ll call them: CW, EW, DSS and LNT) – CW and EW are taught to two classes, and DSS and LNT are taught to two different classes. There are 5 syllabus items for each lesson that need to be covered for each class. The course runs for 10 weeks. I’ve calculated the number of unique records will be 16000 The coverage of each week’s content depends largely on the level of the students, the teacher and/or any supplementary material used. On my php page, if a syllabus item is covered teachers need to check it as completed (checkbox). Any additions to the lesson need to be added to a comments field (textarea). Teachers should be able to log into to see their records (stored on the mysql database and accessed through php pages) and then be able to filter their records by week, class and lesson using drop down lists. The question I have is: What is the best way to set up the mysql database so that each record is unique so that I can accomplish the above? Fields: ID(int), content(text), teacher(text), course(text), week(int), completed(int) and comment(text) Running MySQL client version: 5.0.51b on Windows XP
View Replies !
Setting MySQL Host
I'm looking to grant access to a MySQL database based on a range of IPs. I did a search on the forums here and couldn't find exactly what I was looking for. The IP range is actually only 2 IP addresses but I'm sure there must be a way of setting the Host to accept something like: 123.123.123.*.Currently I can't test it as I don't have access to the web servers, but it someone could tell me the surefire way of doing this it will be one less worry for me .
View Replies !
Setting Up New Mysql Accounts
I have followed the manual for MySQL 5.0 for adding new accounts to MySQL but it will not work for me. I am typing these commands on the root on the actual computer with Every time I input these following commands, the command just returns this: mysql> Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON *.* TO 'myusername'@'localhost' -> IDENTIFIED BY 'mypass' WITH GRANT OPTION; mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP -> ON mydatabase.* -> TO 'myusername'@'localhost' -> IDENTIFIED BY 'mypassword'; I've also tried this one mysql> CREATE USER 'myusername'@'localhost' IDENTIFIED BY 'mypassword'; But it returns mysql> ERROR (HY000): Opteration CREATE USER failed for 'myusername'@'localhost' .
View Replies !
Setting Up MySQL Administrator
I just downloaded MySQL Administrator and am trying to install it. I'm trying "localhost" and "root" for Server Host and Username, along with the default setting for Port, 3306. However, I don't have a clue what a "Stored Connection" is. What am I supposed to enter there?
View Replies !
Configuring/Setting Up MySQL 5
Im a complete newbie to mac os x. I downloaded and installed mySQL 5. I installed it and now i cant seem to connect. I have absolutely no idea what im doing. Im not familiar with os x termial commands. I need someone to email me and explain to me everything i need to do in order to create a user and successfully login using mySQL admin. I've been struggling with this for over a week. Ready to pull my hair out. And please dont refer me to online resources, ive read them all and still cant figure it out. I need a professional who can give me a step by step process to get this going.
View Replies !
Setting Priviledges On MySQL
having a problem setting up users on MySQL, my database is currently running using the default settings. I have scoured the documentation for both PHPMyAdmin and MySQL and am still none the wiser.
View Replies !
Setting Up The MySQL Password
I can't seem to see the page whan I am trying to set up the 'Setting Up the MySQL Password'. I know this is right at the start but all I get when I type in the Web browser http://127.0.0.1/myadmin is the sourcecode and not the actual log in page... I know it's something silly I have done or not done (I have installed the Apache / MySQL / PHP stuff over and over again, but it still does the same thing to me. The Apache services is running fine. The WinMySQLadmin is on green so I know that's fine. I think it's maybe an explorer thing? but I can't seem to get it.
View Replies !
Setting MYSQL Rules
i got table with one column of dates - time(). how i can set a rule inside the mysql -not on asp pages... the rule- take the maximum value and delete all the values that "smaller" than the maximum value, in 20 min
View Replies !
Setting Up MySQL On Mac > Leopard
PHP Code: $link = mysql_connect ("localhost" , "Cretaceous" , "Dinosauria") or die(mysql_error());mysql_select_db ("Trex", $link) or die(mysql_error()); and put it on a test page. When I preview it in a browser, it gives me the following error message: Code: Access denied for user 'Cretaceous'@'localhost' (using password: YES) I checked the privileges, as follows: User (Cretaceous), Host (%), Password (Yes), Global privileges (USAGE), Grant (No) It looks like my user name and password are OK. I changed the database name from Trex to trex (all lower case), but I get the same error message. Since the Privileges page lists the Host as %, rather than localhost, do I have to make some sort of change there? I replaced "localhost" with % in my database query but that doesn't work.
View Replies !
Setting Up MySQL Administrator (have WHM)
I would like to set up MySQL Administrator. (MySQL is taking up 50+ % of my CPU, and I'm not sure why...) I'm having difficulty connecting to my MySQL db. I'm fairly sure I have the correct username and password. For the host, I just used my server's IP and for the Port, I have 3306. When I try to connect, I receive the following error... MySQL Error Number 1130 Host '<IP address>' is not allowed to connect to this MySQL server. I tried adding <IP address> to the MySQL Access Hosts using WHM, but don't think it's working. In fact, I think when I initially tried it... my phpmyadmin stopped working and I had to go in manually to the config file and fix it up.
View Replies !
Setting MySQL Parameters Via PHPmyadmin
What is best selection for 'collation' parameter - for those, who need use two languages, latin(english) and cyrillic(russian) on website and need that mySQL handled and stored both languages correctly? What need be specified in "MySQL connection collation" field?
View Replies !
MySQL Performance - Option Setting
I set OPTION=3 in my connection string as recommended by MySQL (http://dev.mysql.com/doc/refman/5.0...parameters.html) for a VB application. OPTION=3 is Don't Optimised Column Width (1) and Return Matching Rows (2). I found this to be very slow on a database with just 27,000 records. It took approx. 12 seconds to read 27,000 records. When I change the OPTION to 8 (Allow Big Results), it took just 3 seconds to read 27,000 records. BUT now my application cannot update records anymore and getting random errors on transactions. I try setting OPTION=11 (all 3 options added together) and the speed went back to being slow.
View Replies !
Setting Up Mysql Tables For UNICODE
I am willing to setup my MySQL tables so they can hold international strings (English, French, German and Spanish). I understand that Unicode character coding is a good candidate to do so. Currently I use the default character set and it looks like it does not like characters such as "é", "ô" .etc... (they come up as strange characters probably indicating that the code of the character has been truncated). Is my understanding correct? If yes, could anyone lead me through on how to create such tables coding text as Unicode? I went through the MySQL administration guide but cannot get a clear understanding on how this is supposed to be performed. Ideally I would like to setup the MySQL *server* for it to process the tables with the Unicode character set *by default * (rather than specifying each tables one by one as using Unicode encoding).
View Replies !
Setting Up Initial Accounts In MySQL
I'm a newbie to MySQL. In setting up my initial accounts, I see two anonymous users in the mysql database in the user table. My book says to delete them which I did, but I still see what looks like two root accounts. Is this normal? If not, which one do I delete? I see one doesn't yet have a password; should I delete the one without a password? First I'll log out and log back in as root to see if that other root user is a phantom or is really an account. Next, I'll need to add a few users, but I need to make sure this root thing is correct. Here's a screen shot of wht I did: mysql> use mysql Database changed mysql> select user.user from user; +------+ | user | +------+ | | | root | | | | root | +------+ 4 rows in set (0.02 sec) mysql> delete from user where user=''; Query OK, 2 rows affected (0.01 sec) mysql> select user.user from user; +------+ | user | +------+ | root | | root | +------+ 2 rows in set (0.00 sec)
View Replies !
Sorting Columns. Setting Up Mysql ?
Interested in setting up information in columns to sort in ascending and descending order. I'm hoping to set up a clickable image for both options. I know basic html design, I'm just not sure where to start in mysql. Not sure how to set up the table and where to link them to php pages.
View Replies !
Setting MySQL Variables At Start Using My.ini
I am battling to set the default datetime_format in my.ini, if i add the line i want to change the setting, the service refuses to start! The line i am adding is as follows: set-variable = datetime_format="%y/%m/%d %H:%i:%s" Am i doing something wrong here?
View Replies !
Setting Password For MySQL From WAMP?
A few months back I installed WAMP (one big installation of Apache, MySQL and PHP for Windows). The last week I'm busy with Portal development. As a result I'm trying to install Jetspeed-2. The installer of Jetspeed asked what Database I would like to use. As I installed WAMP I thought it wiser to stick to MySQL. When I started phpMyAdmin I saw the following message: "Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account." As it is some time since I installed WAMP I cannot remember what I need to do. I searched the install directory and found that the word password is contained in several .ini files (my-huge.ini, my-innodb-heavy-4G.ini, my-large.ini, my-medium.inim and my-small.ini, but not in my.ini). The format of the line is: #password= your_password I take it I need to remove the # at the start of the line, replace 'your_password' with a password of my choosing? But in what ini file? How does WAMP know what ini file to choose? In the same directory as the ini files I see a wampserver.conf file. In it there is an entry: $mysqlConf['mysqlConfFile'] = 'my.ini'; Does this entry make WAMP to choose for my.ini? I plan to use the WAMP/MySQL installation purely for development purposes.
View Replies !
MySQL Setting Collation To Latin1_swedish_ci
No matter how I configure MySQL 4.1.9, I always end up with all of my tables having collation set to "latin1_swedish_ci". I have tried setting the collation to "latin1_general_ci" but my settings are ignored and all tables show up as "latin1_swedish_ci". The tables that were created have been created and all data inserted through a PHPMyAdmin SQL file export under a server running MySQL 4.0.22. Is there any way to fix this and what is might be causing it.
View Replies !
Setting Up PHP And MySQL To Work Togather.
I can't get MySQL and PHP to work. I've installed MySQL ver.5.0.3 or so on my PC (winXP) on my D: drive, after that i've installed Apache2 serv. also on the D: drive and afterward came PHP5 as a Apache module. I've tried testing if it works. Code:
View Replies !
Setting UP MySQL To Work With Dreamweaver And PHP
I'm trying to set up Dreamweaver to work with PHP and MySQL but cannot get Dreamweaver to recognize my database. I currently have PHP running under Microsoft IIS on my Windows machine and MySQL installed and running. I'm accessing it through MySQL Administrator and also MySQL-Front and don't have any problems connecting to the database in either of these programs. I've set up a DSN for the database, under ODBC Data Sources, and I'm using a virtual directory under IIS for the web pages I'm developing. When setting up a database connection though in Dreamweaver, I get an error message that says "An unidentified error has occurred" As far as I can tell, I have MySQL set up for Root access and also anonymous access. Any suggestions about what I'm missing to get this to work?
View Replies !
Setting Mysql Root Password On Mac
Am having problems setting the root password for the mysql server on my computer. I'm using Mac OS X with apache, php 5 and mysql 4.1 installed. I've tried using the terminal utility but I've had an error message reading:
View Replies !
Setting Root Password For MySQL
I'm Using the "Build Your Own Database Driven Website Using PHP and MYSQL" by Kevin Yank. On pg. 22 where the arguments new password are in parentheses, I typed in new password instead of my own new password ( I know that was dumb!). Anyway, when I quit the Mysql and start over I get the error: cannot login to local host password not excepted. How do I restart so that I can create a root password for Mysql?
View Replies !
Setting MySql Root Password
I feel a bit daft as I can't seem to get passed p21 of Database Driven Website by Kevin Yank. But I'm learning Ive got the latest copy and and want to follow it through to see what i can learn (lots I'm sure) Im on a mac osx and am trying to set the root password. He says to do this using terminal in the bin directory of my MySql installation. Where is it? i know basics about getting round terminal i.e changing directories and stuff.
View Replies !
Lost Connection To MySQL Server During Query (LAMP Server)
I recently installed an ubuntu LAMP server for my website and upon trying a script that uses a mysql database (which I set up the tables via phpmyadmin) and I get this error: Warning: mysql_connect(): Lost connection to MySQL server during query in /home/tanner/Desktop/bot/DoctorWho/db_connect.php on line 4 I've searched the forums and I've gotten no answers. Anyone know the answer?
View Replies !
ERROR When Setting Password Via Console (MySQL V 5.1.30
I am trying to set a password via the console with the following: mysql> update user set pasword - password<'password'> where user = 'root'; and receive the error message: ERROR 1064 <42000>: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where user = 'root'' at line 1
View Replies !
Lost Connection To MySQL Server During Query / Server Has Gone Away
All of a sudden the server stopped working. When trying to execute a simple INSERT both from PHP and Query Browser, the server crashes and I get either "Lost connection to MySQL server during query" or "Server has gone away" errors. The problem started on 5.0.18, and upgrading to 5.0.41 didn't help. I'm using Windows XP SP2. I've seen quite a few posts on similar problems, but no real solutions though. Is that a bug?
View Replies !
Mysqldump From Server To Server OR Move Folder /var/lib/mysql?
I need to move db's from a live server to a new server. The new server will be replacing the existing server once it's setup, and I need to move the DBs in order to do the testing. My question is this; if I use mysqldump to get a dump of all the DBs on the existing old server, and then import that .sql file to the new server, will that copy over *EVERYTHING* i need to get the DBs working again? Privilages etc ? The alternative that I am considering is to move the /var/lib/mysql folder along with mysql.cnf. That should work, as we can change any locations in the mysql.cnf file, but it does mean taking the server offline while we tar the databases, which could take 30 mins or so.
View Replies !
SQL Server 2000 To MySQL Server
I'm trying to do an export from an SQL Server 2000 Database to and ODBC driver pointed to a mySQL Server Database. The export works if there is at least one record in the mySQL table. If the mySQL table is empty it gives an error that looks like this: Insert error, column 1 ('field1', DBTYPE_STR), status 6: Data overflow. The strange part is that the export works perfectly fine as long as there is one record in the mySQL table, if there are no records in the table, I get the error above.
View Replies !
Mysql Server And Regular Server
I recently decided to get another server to do just mysql, however, I ran into a few problems. As soon as I switch the script to pull from the other server it creates a huge lag between the two and eventually starts timing out the sites. in my.cnf i did do skip-name-resolve but still the same thing. Are there any programs or anything that are maybe bottlenecking it because the site will load in the first 10 secs after i switch the mysql (with a lag) but that lag gets bigger and bigger. The mysql error log doesn't show anything weird either. To further complicate things, another server that was pulling off it worked for the first few hours, then when traffic started to increase, it started doing the exact same thing. (both server loads were low and max connections was not getting even close). Roughly 600 qps, half to HEAP tables.
View Replies !
|
TRACKER
