MySQL Server Startup Issues
For some reason I cannot get my MySQL server to start. It has been
running fine until Friday, when we has a strange issue with the
Solaris server which it is running on. The server had a few files get
their chmod setting messed up and now after fixing that, MySQL won't
start.
Exerpt from neuro18.err:
040830 15:55:19 mysqld started
040830 15:55:19 Can't start server : UNIX Socket : Permission denied
040830 15:55:19 Aborting
040830 15:55:19 /usr/local/mysql-standard-4.0.20-sun-solaris2.8-sparc/bin/mysqld:
Shutdown Complete
040830 15:55:19 mysqld ended
ps -ef|grep mysql yeilds no other mysqk processes running.
ls -l in /usr/local/mysql yeilds:
-rw-r--r-- 1 root mysql 19106 May 13 20:14 COPYING
-rw-r--r-- 1 root mysql 8403 May 13 20:14 INSTALL-BINARY
-rw-r--r-- 1 root mysql 1937 May 13 19:53 README
drwxr-xr-x 2 root mysql 1536 May 13 21:59 bin
-rwxr-xr-x 1 root mysql 773 May 13 21:59 configure
drwxrwxr-x 9 mysql mysql 512 Aug 30 15:55 data
drwxr-xr-x 2 root mysql 512 May 13 21:59 docs
drwxr-xr-x 2 root mysql 1536 May 13 21:59 include
drwxr-xr-x 2 root mysql 512 May 13 21:59 lib
drwxr-xr-x 3 root mysql 512 May 13 21:59 man
drwxr-xr-x 6 root mysql 512 May 13 21:59 mysql-test
drwxr-xr-x 2 root mysql 512 May 13 21:59 scripts
drwxr-xr-x 3 root mysql 512 May 13 21:59 share
drwxr-xr-x 5 root mysql 1024 May 13 21:59 sql-bench
drwxr-xr-x 2 root mysql 512 May 13 21:59 support-files
drwxr-xr-x 2 root mysql 512 May 13 21:59 tests...
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Can't Startup Mysql Server
I hv just kill the mysql server process ( by killing the process ID ) , not normally shutdown the mysql server ( mysql stop ) , now the mysql can't start , I also can't find any process related to mysql , except reboot the server , can suggest how to start the server again ?
View Replies !
View Related
Statments Issued Ad Server Startup
I would like to issue three statements to the database (mysql v4.1) each time the server starts up. Is there any built in way to do this? Like a init file to put them in? At the moment I have a perlscript that starts the server and issues these statements but I have to supply password each time.
View Replies !
View Related
Server Not Using Startup Variables When Restarting?
I wanted to change the Max Connections from the default of 100 to 500. To do this I went (using MySQL Administrator) to the Advanced Networking tab under the Startup Variables section. Changed the value of Max Connections to 500 and clicked on Apply Changes. Then to actually apply the changes I went to the Service Control section and restarted the MySQL service. However, after this it doesn't seem to have actually changed, when going to the Health section it still displays a maximum of 100 connections under the Connection Usage. I've checked that the service is using the correct my.ini file (under Configuration File section on Service Control->Configure Service) and also that the my.ini file is updated correctly, that is that under the [mysqld] section there is a line: max_connections=500.
View Replies !
View Related
Server Load Issues
Im not sure if this is the right section since the problem is probably a combination of mysql/apache config issues.Firstly, the server is running FreeBSD and is a dual xeon with 1.5GB RAM and 4GB swap. The loads are around 3 most the time but spike to 6-7 every few minutes. mysqladmin status shows 500 queries a second (the site gets a few hundred hits a second).Ive tried searching for some optimal configs but google didnt turn many up, most the queries are selects but some of them have fairly complicated joins (5-6 joins in same query).Everything which is used in order by, where or in a join is indexed and some of the tables which have temp data have already been setup as heaps.
View Replies !
View Related
MySQL Startup
i dowunloaded the sources of mysql 4, i compiled it under slackware 9...no errors on configure, make & make install.... I created db (mysql_install_db) and root db password (mysqladmin root -u password) and no errors. The problem is that when i type mysqld_safe & i get the following error : ./mysqld_safe & [1] 5113 root@darkstar:/usr/local/mysql/bin# Starting mysqld daemon with databases from /usr/local/mysql/var 030624 12:33:22 mysqld ended .
View Replies !
View Related
Mysql Freezes On Startup
I've got a mysql server running on linux. It was working fine until this morning when a customer wrote and told me it was not working. On investigation it had frozen. I stopped and restarted it this is on an fc3 box, i get the starting mysql message but never get a prompt back. I don't see any output in my /var/log/messages.1 file.
View Replies !
View Related
MySQL Startup Scripts
Would anyone explain me why the startup scripts check for command line arguments and the contents of /etc/my.cnf right after setting the env variables such as basedir, pid-file and so? if the MySQL code and scripts are expected to be on a specific hardcoded location (yeah, right we could specify this at build time) why bother supporting those variables at all? shouldn't they run parse the command line and defaults file first before setting defaults.
View Replies !
View Related
Install And Startup Mysql
I cant get mysql to run on my winXP computer. I have downloaded it and installed , unzipped and run setup.exe and placed it in c:mysql. I type the command to start the mysql server c:mysqlinmysqld --console It opens the console and then the console shows some inoDB commands and the console hangs. I followed the mysql manual and i cant find the answer there is no command prompt and nothing...how do I run mysql?
View Replies !
View Related
Mysql Startup Script
I have mysql running on a freebsd box. When the machine boots it does not automatically start mysql, despite "mysql-server.sh-dist" being in the /usr/local/etc/rc.d file. This means that I must run "/usr/local/etc/rc.d/mysql-server.sh-dist start" manually to get mysql to start. Does anyone know of a way to make mysql start automatically when the freebsd box starts?
View Replies !
View Related
MySQL Error (*not* 1067) Soon After Startup On XP Pro
I had this problem with 4.0.17 so I upgraded to 4.0.20D, alas with to no avail. I could install the service succesfully with mysqld --install. When I started the service I got a message saying "The MySQL service was started succesfully" but a second later it died. Windows popped up with the usual message "mysqld has encountered a problem and needs to close....blah....blah". The details of that error is as follows: ================================================ szAppName : mysqld.exe szAppVer : 0.0.0.0 szModName : unknown szModVer : 0.0.0.0 offset : 00000000 ================================================ Similar thing happened when I tried to do mysqld --console. I got the "mysqld has encountered......blah" with the following details in the error message: ================================================ AppName: mysqld.exe AppVer: 0.0.0.0 ModName: mysqld.exe ModVer: 0.0.0.0 Offset: 00257865 ================================================ This also applies to another binary which I normally use, max-nt. There's more to the error messages but they're too long to include in this post. Does anyone have any idea what this means?
View Replies !
View Related
Prevent MySQL From Starting At Startup
I'm starting to play around with MySQL. How can I prevent it from starting up whenever my computer starts? It slows down the startup some, and I'm not always wanting to use it. besides, I can start it myself if I need it.I've had a look on Google for theis, and found quite a few results, but they were fo Linux or Unix. I'm ruinning Windows XP.
View Replies !
View Related
Mysql Shell Startup Script
When starting up the mysql shell, is there a way that I can automatically run a startup-script ? Specifically, I would like to issue a BEGIN WORK everytime I open up the shell. I tried man mysql, but didn't get any the wiser.
View Replies !
View Related
MySQL 4.020c (Windows) Service Startup Error
I installed MySQL 4.0.20C and it works if I started it with mysqld --console However, if I do the following: mysqld --install net start MySQL I got the following error: D:mysql>net start MySQL The MySQL service is starting. The MySQL service could not be started. A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly. Does anyone know what I have don't wrong? I was using Windows XP on my notebook with latest security patches applied.
View Replies !
View Related
Linux RHE5 Startup Script For Multiple MySQL Instances
I have 2 instances of mysql 5.0.67 installed on one server. They are under 2 separate linux accounts (mysql & mysqldev). Each is installed in a non-standard location: mysql: /opt/mysql/5.0 mysqldev: /opt2/mysql/5.0 Each uses its own data directory: mysql: /ua01/mysqldata mysqldev: /ua03/mysqldata I have ONE /etc/my.cnf file owned & grouped as mysql. The my.cnf file contains the following (commented lines at beginning and end of the file are omitted): [mysqld_multi] mysqld = /opt/mysql/5.0/bin/mysqld_safe mysqladmin = /opt/mysql/5.0/bin/mysqladmin # Here follows entries for some specific programs # The MySQL server for STAGING [mysqld1] mysqld = /opt/mysql/5.0/bin/mysqld_safe mysqladmin = /opt/mysql/5.0/bin/mysqladmin port = 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M # TNC specifics basedir=/opt/mysql/5.0 ledir=/opt/mysql/5.0/bin datadir=/ua01/mysqldata log=/opt/mysql/admin/log/cricket.log log-error=/opt/mysql/admin/log/cricket.err pid-file=/opt/mysql/admin/log/cricket.pid log-bin=/dbarchive/mysql/cricket-bin.log....
View Replies !
View Related
Mysql & Xp Issues
I'm not exactly a novice to computing or developing but I am a total novice with mySQL and anything that stems from it and after a trying several tutorials out and searching the forums, I am still stumped. SO any help would be appreciated.I am trying to install a 4.1 release of win32 mySQL and am having major problems getting a server to run at all. (it doesn't have to be 4.1)I get as far as installing it and then an auto configurator pops up and tries to set it up and then fails miserably. I need this for OpenCMS (OpenCMS.org). Any advice welcome. Though if that advice is to remove xp or dual boot I need to look at other options.
View Replies !
View Related
MySQL Issues
I have a few issues related to MySQL. Here are they: 1. As MySQL is acquired by Sun it is not clear how much effort Sun will provide to develop MySQL. 2. The cost might change after the acquisition from Sun which might affect the popularity of MySQL. 3. MySQL might not be suitable for large organisation. 4. Absence of stored procedures, sub-selects and triggers. (Check) 5. Failure to meet the ACID test - it is perfect though for storing/tracking non-critical data. (Check) Does MySQL 5 corrects these issues? How many of these are sorted in the latest version?
View Replies !
View Related
MySQL 5 Issues
I upgraded from 4.1 to 5.0 just to see if there where any changes that would break my application. After a lot of troubleshooting trying to track down the issue I was able to pin it down.I am using php 5 and a MySQL based session layer. After successfull login the login script redirects the user to the members area. It seems the INSERT used to save the user information for the session is not being completed before the members page loads so the login fails. I can fix this by doing 2 diffrent things 1. Backing down to MySQL 4.1 and everything works 2. Pausing the script for 1 sec prior to forwarding ( therefore giving mysql time to update ) works as well.
View Replies !
View Related
XAMPP Issues: MySQL
i am having trouble setting up my server. I have the latest XAMPP running on a windows98 machine. I have just installed it and I have to admit I am a total new-b at this but i managed to find the Apache configuration file and configure a few things like the listen port because my ISP blocks the default 80 for incoming, i configured the document root and also i saw this and did not know if it was important but i still configured it: # ServerName gives the name and port that the server uses to identify itself. # This can often be determined automatically, but we recommend you specify # it explicitly to prevent problems during startup. # # If your host doesn't have a registered DNS name, enter its IP address here. # ServerName XX.XX.XX.XX:PORT# ofcourse the X's being my IP address and port number at the end. So im wondering is this the name that you use to connect to MySQL ? if so with or without the port number? once again i am a total new-b to this, I have no idea. I am however currently reading "PHP and MySQL for Dummies", lol. and it has this test script i guess to check if MySQL is up and running: Code:
View Replies !
View Related
Mysql Too Many Connections Performance Issues
I have a website running on a linux/apache/mysql/php server. I receive about 8,000-10,000 visitors a day with about 200,000 to 300,000 page views. The server is a RedHat Linux server running PHP 5.x, MySQL 5.x, Apache 2.x We have been suffering from a number of performance issues. Our hosting company has set our max connections to 100, and we are using persistent connections in PHP. At times the mysqld process takes 100% of the CPU. We have also been suffering from mysql_pconnect(): Too many connections errors. What can I do to fix these issues? When I run a top on the server I see this ... PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 5567 mysql 16 0 169m 42m 4236 S 81.2 4.2 3078:09 mysqld 32539 apache 15 0 42676 25m 7708 S 1.0 2.5 0:03.40 httpd 32572 apache 15 0 42680 25m 7708 S 1.0 2.5 0:02.98 httpd 32608 apache 15 0 42680 25m 7704 S 1.0 2.5 0:00.72 httpd 32542 apache 15 0 42704 25m 7712 S 0.7 2.5 0:03.38 httpd 32561 apache 15 0 42732 25m 7712 S 0.7 2.5 0:02.61 httpd 32567 apache 15 0 42680 25m 7708 S 0.7 2.5 0:02.60 httpd 32591 apache ...................................................
View Replies !
View Related
MySQL Command Issues With An ADO Recordset
I know you will probably say that I should use MS SQL Server DBs with ASP, but my MySQL and ASP combo works and is affordable for me and up until now didn't give me any grief until recently. In essence, the following MySQL query commands cause my ASP to generate a Type Mismatch error when I try to response.write the result of the query fields: Query 1 CONCAT(PICFILEWIDTH,' x ',PICFILEHEIGHT) I call this query result into a dynamically-created array from a recordset object, ie arrSQLData (the array) = oRSv.GetRows() (the recordset object), but when I call say arrSQLData(0,0) it generates the type mismatch. This used to work fine in the MySQL v4 something that had the crappy installer, but since they made the new installer (and some other mods) it causes this problem. I've checked the MySQL site and it says that the above, which is an int, ' x ', another int is fine, but something in ASP doesn't like the result it sends back. Done a straight query from SQLyog and that displays it OK. Query 2 IFNULL((sp.RRPTAX/sp.RRPNET),'0.00') same again this generates a type mismatch when it used to work fine. Obviously the command puts in 0.00 if the tax and net values are null, but this doesn't work now. It generates a type mismatch. Has anybody had this problem and fixed it?
View Replies !
View Related
W2K Shutdown Issues After MySQL 5 Install
Has anyone heard of MySQL5 causing W2K to have problems shutting down? I'm running a 2K Server with MySQL 5.0.16 and noticed that after the install, the server would not shutdown cleanly. If I disable the MySQL Server prior to shutdown, the server shuts down or restarts without a problem.
View Replies !
View Related
MySQL 4.0.18 InnoDB Configuration Issues On SuSE 9.1 Pro
I've tried resolving this issue in a SuSE newsgroup, but after trying their suggestions and working on this issue for far too long already, I decided to try this list as it may be a more appropriate discussion area. I've installed and configured MySQL 4.0.18 on a SuSE 9.1 system using the default RPM's that came with the distribution. I created a simple database (one table with InnoDB engine type) and have tried running some ODBC source against it to test transactions, but I get the error that the server does not have transactions enabled. I was directed to enable transactions in the configuration file (/etc/my.cnf) by uncommenting the lines for innoDb use. However, after uncommenting these lines and running mysqld from the commandline (according the online Manual), to generate InnoDB support tables, I get the following error: mysqld: ERROR: unknown variable 'innodb_data_home_dir=/var/lib/mysql/' I've tried removing the RPM's and starting from scratch, but cannot get past this error and successfully test transactions in my unit tests.
View Replies !
View Related
Performance Issues In Iterative Concurrent Inserts In Mysql 4.0.18
I am using Mysql 4.0.18 and executing concurrent insert statement. I am executing this statement in the loop. For first few interation the perofrmace is quite good, the query executes in almost 5 to 6 second (Records being fetched and inserted are near about 80000 to 1,00,000). But as the no of iterations go on the execution time also increases. It goes upto 2 - 3 mins for a single query?
View Replies !
View Related
Botched Mac Mysql Installation - Permission Related Issues
Code: jon-reids-power-mac-g4:~ jon$ mysqld_safe touch: /usr/local/mysql/data/jon-reids-power-mac-g4.local.err: Permission denied chown: /usr/local/mysql/data/jon-reids-power-mac-g4.local.err: Permission denied Starting mysqld daemon with databases from /usr/local/mysql/data /usr/local/mysql/bin/mysqld_safe: line 380: /usr/local/mysql/data/jon-reids-power-mac-g4.local.err: Permission denied rm: /usr/local/mysql/data/jon-reids-power-mac-g4.local.pid: Permission denied /usr/local/mysql/bin/mysqld_safe: line 386: /usr/local/mysql/data/jon-reids-power-mac-g4.local.err: Permission denied STOPPING server from pid file /usr/local/mysql/data/jon-reids-power-mac-g4.local.pid tee: /usr/local/mysql/data/jon-reids-power-mac-g4.local.err: Permission denied 080616 21:52:09 mysqld ended tee: /usr/local/mysql/data/jon-reids-power-mac-g4.local.err: Permission denied jon-reids-power-mac-g4:~ jon$ sudo mysqld_safe Password: Starting mysqld daemon with databases from /usr/local/mysql/data
View Replies !
View Related
Startup
I have just installed "fedora core 3" with taking everthing that come with it. Now I want to use the "mysql database",but when I run "mysql" command it says "check that database is running". and also "/var/lib/mysql/mysql.sock not found. 1. How to check that database is running or not? 2.How to create mysql.sock file. i have not installed any network card at all.I am workinf on the same pc in which I have installed the "fedora core 3".
View Replies !
View Related
Ndb_mgmd Can't Startup
I am trying to setup the mysql clustering , I hv followed the manual to setup it , but when start the management server ( ndb_mgmd ) , it pop the below messages , I didn't add any parameter when startup it , could suggest what is wrong ?
View Replies !
View Related
Mysqld Startup
I'm using ssh to administer a mysql server, version 3.23.49, which I just installed. The problem when starting mysqld: I type "mysqld" at the shell prompt and hit return, then I get the message "mysqld: ready for connections". But then it doesn't give me back the shell prompt. I can type stuff on the screen, but it doesn't do anything. I've tried Ctrl-C and Ctrl-Z, but that does nothing. Any ideas?
View Replies !
View Related
Mysql_4.0.20 Startup
I have compiled (sparc solaris 9 box) and installed mysql 4.0.20 and face the following error. I have copied the startup script to /etc/init.d/mysql and linked it to /etc/rc3.d/S99mysql (as indicated in the sample file). When the system boots mysql doesn't start automaticallyb (rights are OK). Going through the error logs i found that it can't locate the libstdc++..... library which is under /opt/sfw/lib. When I run /etc/rc3.d/S99mysql start after I have logged in as root, mysql starts. Note that the LD_LIBRARY_PATH is setup and the path to the library is included.
View Replies !
View Related
Auto Startup...
My VB6 app uses MySQL (5.0), ODBC Connector (3.51). When I start my app manually all is good and that's probably because service and connection is available. If I put my app in the Startup folder to run after the system boots up the MySQL Driver Connect screen pops up and waits for the OK to continue and my app fails because it can't connect to it's database. So what should I do? I can't be there to click on OK, it's too late anyway.
View Replies !
View Related
Startup Processes
I'm trying to find out the startup process of mysql. How it starts, the files it loads and daemons it starts etc. Have been looking over the site for ages but cant find much on it.
View Replies !
View Related
Root Password / Startup
I'm using mysql-server-3.23.58-4 on a Linux (Fedora 1) machine, and I'm new to databases/MySQL. After reading the security section of the manual from http://dev.mysql.com, I added passwords for the 'root' accounts. However, now the startup script (/etc/rc.d/init.d/mysqld) fails. I tried adding: [mysql.server] password=xxx into /etc/my.cnf How do I set the password for the startup script ?
View Replies !
View Related
Create Startup Variable
trying to create the NOCOUNT variable on MySQL startup. So I edited the INSTALLDIRmy.ini file to include the line NOCOUNT=ON in the [mysqld] section but then I couldn't start MySQL instance with that line in there. Did I do anything wrong? How can I create a startup variable on MySQL?
View Replies !
View Related
Mysqld Startup Errors
I get the following message when I try to startup mysqld in the /usr/local/mysql/bin directory. ./mysqld: /usr/lib/libstdc++.so.5: version `GLIBCPP_3.2' not found (required by ./mysqld) ./mysqld: /usr/lib/libstdc++.so.5: version `CXXABI_1.2' not found (required by ./mysqld) I'm running Fedora core3.
View Replies !
View Related
Unable To Resolve Startup Failure
I installed MySql with defaults last night and server worked fine. Made couple of php files and reviewed my handy work in internet explorer no problem. Got home tonight began work again and got error message when trying to access local host. read documentation about startup problems and found error log but do not understand it. A copy follows: ;InnoDB: End of page dump 051108 20:24:39 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432 InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0 InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0 InnoDB: Page number (if stored to page already) 0, InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0 051108 20:24:39 [ERROR] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: Got signal 11. Aborting! 051108 20:24:39 [ERROR] Aborting 051108 20:24:39 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: Shutdown complete Went to Xp admin services and tried to start couple of times but got same message each time.
View Replies !
View Related
Php Startup: Unable To Load Dynamic Library ...
I've been reading some threads with the same problem, so I uncommmented the extension module for php_mysql.dll and I set the extension_dir = "c:phpext" . It still says that its unable to load the dynamic library 'c:phpextphp_mysql.dll' when I KNOW its in that directory along with the root directory as well. I have configured the apache httpd.conf with the LoadModule php5_module C:/php/php5apache2.dll and added #PHP 5 ScriptAlias /php/ "c:/php/" AddType application/x-httpd-php .php Action application/x-httpd-php "/php/php-cgi.exe" at the end. So does anybody have any ideas so that maybe I can connect to mysql with php with one less problem.
View Replies !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
Issues With IF()
Has anyone noticed issues with IF() or IF(expr1, CONCAT(exp1, exp2), CONCAT(exp1, exp2)) after upgrading from MySQL 4.0 to 4.1? A query in our system seems to be hanging and eating up some serious CPU usage (around 99%), yet on 4.0, the system seems to breeze through this query.
View Replies !
View Related
Log In Issues
I just started my MySql account from my Yahoo Small Business Webhosting account. I'm confused now, becuase I installed the PhpAdmin tool that they told me to, but now I can't sign into it. The PhpAdmin site says this is a MySql issue. It appears that my username and password aren't correct. I am positive that I'm giving the username and password that I created when I created my MySql database a few minutes ago. I keep getting this error message: #1045 - Access denied for user 'root'@'localhost' (using password: YES). I tried resetting my password (to the same password that I gave when I started the account and also tried setting it to an entirely new one). The Yahoo help files said: "If your PHP or Perl configuration files require a host name, you may have a problem with your host name. Make sure that you are using the host name mysql, not the default host name localhost." I'm confused as to what username I should be typing, in this case.
View Replies !
View Related
Collation Issues
by default, my collation is set to latin1_swedish_ci, which I think is normal, but how do I switch that to normal English, or utf8 and keep that there as the default?
View Replies !
View Related
Grant Issues
The scenario is as following: 1. I have a database with 240 tables. 2. I can access all these tables on local host 3. I can access only 5 tables from another remote IP/client. 4. Only one of these tables is listed in "information_schema", look at following query: .....
View Replies !
View Related
|
TRACKER
